The Key To Hit Your Targets In Life, Learnt From The Legendary Archer:
'via Blog this'
Friday, 29 April 2016
Thursday, 28 April 2016
Wednesday, 27 April 2016
Qlikview Bitz and Pieces: Top N in Qlikview Straight/Pivot Tables and Charts
Qlikview Bitz and Pieces: Top N in Qlikview Straight/Pivot Tables and Charts: "aggr(if(rank(sum([Gross Room Nights]))<=10,[Hotel Market]),[Hotel Market])"
'via Blog this'
'via Blog this'
Monday, 25 April 2016
Friday, 22 April 2016
Thursday, 21 April 2016
Wednesday, 20 April 2016
Tuesday, 19 April 2016
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'
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'
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'
Monday, 18 April 2016
Contents of “Development and Deployment of Multiplayer Online Games: from social games to MMOFPS, with stock exchanges in between” - IT Hare on Soft.ware
Saturday, 16 April 2016
Thursday, 14 April 2016
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'
YearMonth=, OrderDate={'<=$(=max(OrderDate))'}>} OrderDate)>=$(=max(OrderDate)-30)"}>}
distinct Customer)"
'via Blog this'
Is possible to use alternate States with set an... | Qlik Community
Is possible to use alternate States with set an... | Qlik Community: "SUM( { State1Name < [Field1]=[State2Name]::Field1>} Sales )"
'via Blog this'
'via Blog this'
Wednesday, 13 April 2016
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'
for each File in filelist(vFolder& '\*.qvd')
load * from [$(File)] (qvd);
next File"
'via Blog this'
Tuesday, 12 April 2016
Monday, 11 April 2016
Sunday, 10 April 2016
Saturday, 9 April 2016
Saturday, 2 April 2016
Friday, 1 April 2016
Subscribe to:
Posts (Atom)