Displaying One week data

[Anonymous]

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!

[Gysbert_Wassenaar · Accepted solution]

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.

[jagan]

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.

[Anonymous]

Thanks a lot for the help

[Anonymous]

Thanks a lot for the help.