Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have date values from the start of the year to July 2015.
I have to create a pivot table which will show the last week data alone ie. From (Current date -7) to Current date.
So how should i give the dimension in pivot table?
Can anyone help me on this please.
Please let me know if more information is required.
Thanks!
Try changing your pivot table expressions so that it filters your date field for the last 7 days. For example if your expression is sum(Sales) you can change that into sum({<MyDate={'>$(=today()-7)<$(=today())'}>}Sales). If you have trouble getting this to work please post a qlikview document with relevant example data.
Try changing your pivot table expressions so that it filters your date field for the last 7 days. For example if your expression is sum(Sales) you can change that into sum({<MyDate={'>$(=today()-7)<$(=today())'}>}Sales). If you have trouble getting this to work please post a qlikview document with relevant example data.
Hi,
Try like this
=Sum({<DateFieldName={'>$(=Date(Today()-7))<=$(=Today())'}>} Sales)
Note: You DateFieldName and Today() output should be in the same format, then only you will get the result.
Also replace DateFieldName with your actual field name.
Regards,
Jagan.
Thanks a lot for the help
Thanks a lot for the help.