Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
paulwalker
Contributor

Need Help......

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.....

7 Replies
MVP & Luminary
MVP & Luminary

Re: Past 7 weeks data display

Hi,

Please find attached file for solution.

Regards,

Jagan.

paulwalker
Contributor

Re: Re: Past 7 weeks data display

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...........

Capture.PNG

mrooney
New Contributor III

Re: Past 7 weeks data display

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. !

paulwalker
Contributor

Re: Re: Past 7 weeks data display

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,

mrooney
New Contributor III

Re: Re: Past 7 weeks data display

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.

paulwalker
Contributor

Re: Re: Re: Past 7 weeks data display

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....

Capture.PNG




paulwalker
Contributor

Re: Need Help......

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.......