YA(H)Q Blog: Understanding Aggr()

YA(H)Q Blog: Understanding Aggr(): "Min(Aggr(Sum(Sales), Store, Month))
Fractile(Aggr(Sum(Sales), Store, Month), 0.05)
Fractile(Aggr(Sum(Sales), Store, Month), 0.95)"



'via Blog this'

Quick Development Tips: Qlikview: Aggregation 2: Dynamic Aggregation in Pivot Table

Quick Development Tips: Qlikview: Aggregation 2: Dynamic Aggregation in Pivot Table: "vMthLevel = sum(if(aggr(sum(Quantity), Yr,Qtr,Mth,SalesPerson)>2,1,0))
vQtrLevel = sum(if(aggr(sum(Quantity), Yr,Qtr,SalesPerson)>5,1,0))
vYrLevel = sum(if(aggr(sum(Quantity), Yr,SalesPerson)>10,1,0))"



'via Blog this'

Set Analysis – New and Lost Customers with Nested Advanced Search | Evolcon Evolution Consulting

Set Analysis – New and Lost Customers with Nested Advanced Search | Evolcon Evolution Consulting: "count({$0'}, Year=, Month=,
YearMonth=, OrderDate={'<=$(=max(OrderDate))'}>} OrderDate)>=$(=max(OrderDate)-30)"}>}
distinct Customer)"



'via Blog this'

Load multiple qvd files | Qlik Community

Load multiple qvd files | Qlik Community: "Set vFolder = 'D:\New Leads\QVD';
 
for each File in filelist(vFolder& '\*.qvd')
     load *  from [$(File)] (qvd);
next File"



'via Blog this'