Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Given the following Table, I need to compare the Quantity a Month, Quarter Half-Year and Year Ago plus the difference agaisnt YTD (same period of last calendar Year):
LOAD * INLINE
[Date, Product, Qty
08/01/2015, Shoes, 7
01/12/2014, Shoes, 10
01/12/2014, Shoes, 46
01/08/2014, Shoes, 21
01/08/2013, Shoes, 33
];
Is there any suggestion for making this through the relational model at Qlikview? The final pivot must be dynamic; I mean, if the customer selects either Month, Quarter, Half-Year or Year we must get, from the current period, its previous MTD and YTD.
Does anyone who can help me on that? Thanks in advance,
Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations