topic Re: Displaying One week data in QlikView

Displaying One week data

Anonymous — Fri, 10 Jul 2015 07:19:56 GMT

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!

Re: Displaying One week data

Gysbert_Wassenaar — Fri, 10 Jul 2015 07:30:10 GMT

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.

Re: Displaying One week data

jagan — Fri, 10 Jul 2015 07:40:41 GMT

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.

Re: Displaying One week data

Anonymous — Fri, 10 Jul 2015 08:32:50 GMT

Thanks a lot for the help

Re: Displaying One week data

Anonymous — Fri, 10 Jul 2015 08:33:04 GMT

Thanks a lot for the help.