topic Re: Re: Past 7 weeks data display in QlikView

Need Help......

paulwalker — Thu, 27 Nov 2014 03:30:57 GMT

Hi All,

i have one requirement..

So I have list box of WeekDate (I have selected: Always One Selected Value), example when I select 8/18/2014 in list box,

then my Bar chart should display past 7 weeks data from

8/11/2014 (week7), 8/4/2014 (week6), 7/28/2014 (week5), 7/21/2014(week4), 7/14/2014(week3), 7/7/2014(week2), 6/30/2014(week1)

The same way when I select 8/11/2014 then my Bar chart should display past 7 week data from 6/30/2104 to 8/11/2014.

i want to like a dimension week1, week2, week3, week4, week5, week6, week7 like this

and so on...

Can you please help me to achieve.....

Re: Past 7 weeks data display

jagan — Thu, 27 Nov 2014 04:17:27 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Re: Past 7 weeks data display

paulwalker — Fri, 28 Nov 2014 17:27:19 GMT

Hi Jagan,

I have open date and close date, here date ranges..

start date= Open Date

End date = Close date

My Requirement:

These are two calendars StartDate and EndDate

I want to calculate Week wise data..

(W1, W2, W3, W4, W5 and W6)

If i am click StartDate = 10/23/2013 (Open Date)

i want to show past 6 weeks data..

If i am click EndDate = 9/20/2014 (CloseDate)

i want to show past 6 weeks data..

Like this...........

Re: Past 7 weeks data display

mrooney — Fri, 28 Nov 2014 18:45:59 GMT

I paul,

On my view what you need is a canonical date. Find enclosed my try.

Please check my solution. Unfortunately, I have no time to review it in depth (sorry).

Hope it helps.

Regards.

Mike. !

Re: Re: Past 7 weeks data display

paulwalker — Sat, 29 Nov 2014 18:29:39 GMT

Hi Migule,

Thanks for reply...

i have startdate (opendate) and enddate (closedate) these are 2 calendar..

when i am click these 2 dates.. i want to reflect bar chart..

How to pass variable ..???

PFA,

Re: Re: Past 7 weeks data display

mrooney — Sun, 30 Nov 2014 10:06:09 GMT

Hi Paul.

May be i'm not understanding your point quite well.

With the solution i prosope you don't need two calendars anymore.

Now, you just need a canonical calendar date list box in wich you can select a range of dates (from /to). Doing so, you will have the chart showing the data according the set analysis conditions: that is, using the opendate as modfier in one mesure and the closedate in the other one.

I don't think you need variables todo so.

Have a look to this post from Henric: http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Regards.

Miguel.

Re: Re: Re: Past 7 weeks data display

paulwalker — Mon, 01 Dec 2014 17:04:03 GMT

I understood Canonical Method,

My point is,

StartDate: 11/3/2014 EndDate: 23/12/2014

i want to show range data ....(i need to show last 6 weeks data)

StartDate= previous 6 weeks

EndDate= previous 6 weeks

If i am select startdate in my calendar object 8/18/2014.

then my Bar chart should display past 6 weeks data from

8/11/2014 (week6), 8/4/2014 (week5), 7/28/2014 (week4), 7/21/2014(week3), 7/14/2014(week2), 7/7/2014(week1)

same as enddate.......

see this image, i want to show like this....

Re: Need Help......

paulwalker — Tue, 16 Dec 2014 15:53:38 GMT

Hi Miguel,

I need some help,

I have 3 sheets, INDIA, UK and US...

I have done using concatenate with flag in each sheet..

is it right???

please help me out.......