Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm currently in the process of creating my first Qlik Dashboard and need some help please!
I'm looking to recreate a pivot table I currently have in excel.
Is there a way of making the column automatically show only dates in the last week (would need to be mon - sun) but with the ability to change the week view I want to look at? I have pivot set up how I want it, except for the fact it's pulling every day that there is data for. E.g. today I would want it to show data from week commencing 7th September but if I wanted to I could change the view to week commencing 3rd August?
Thanks in advance!
You can use set analysis.
taking a simple example. sales in last 7 days
Sum( {<OrderDate={">=$(=Date(Max(OrderDate)-7))"}>} LineSalesAmount)
So in case of a pivot you would have this expression as measure and Date as dimension.
As we are using Max of date. If you create a filter on orderdate. and you select a previous date the values in pivot will change on it own