Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
Hi,
Please find attached file for solution.
Regards,
Jagan.
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...........
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. !
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,
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.
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....
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.......