topic Re: Show data in graph for last 4 weeks in QlikView

Show data in graph for last 4 weeks

Tue, 13 Jan 2015 14:34:52 GMT

Hey people!

Could somebody please help me. In bar chart i need to show data for last 4 weeks. And because is start of a year 2015, qlikview shows me data just for weeks 2 and 1 (if starting from today). How can I get data also for weeks 52, 51 and 1 in december 2014? So weeks 52, 51, 1, 2 in the same graph? Until now i used variable for week something like that:

Last4Weeks = '>' & (max(Week(Today())-1) - 4) & '<=' & max(Week(Today())-1) and then I used it in a graph in set analysis:

Week = {'$(Last4Weeks)'}. But now is not working anymore properly and shows me just weeks 1 and 2.

Hope I explained well and really hope somebody can help me.

PS: I need something like this also to show data for last 6 months.

Thanks and regards,

Anja

Re: Show data in graph for last 4 weeks

aadil_madarveet — Tue, 13 Jan 2015 14:47:11 GMT

Hi,

What is the dimension you are using for this chart.

Is there any restriction you have put in dimension also.

Re: Show data in graph for last 4 weeks

saurabh5 — Tue, 13 Jan 2015 14:47:21 GMT

Hi Anja,

Try something like below if it works for your scenario:

=Count({<[Date]={">=$(=date(max(Today())-28,'M/D/YYYY'))<=$(=Date(Max(Today())-1,'M/D/YYYY'))"} >}DISTINCT [What ever id u have])

Re: Show data in graph for last 4 weeks

Wed, 14 Jan 2015 07:31:09 GMT

Hi Saurabh,

It's working Except that i put this formula in variable

Thank you very much

Regards,

Anja

Re: Show data in graph for last 4 weeks

Wed, 14 Jan 2015 07:32:23 GMT

Hi Aadil,

My dimensions are Week (from master calendar) and dimension for which i want data to display. I have no restriction in dimensions.