How to create a single comparision graph for different Date ranges?
I am a beginner in qlikview. I'm not sure how to achieve below requirement. Kindly help me with this. Thanks a lot in Advance.
Requirement:
===========
I have four columns in a table as below,
1. Date
2. product type
3. phone_number
Here i have created below calender boxes,
YEAR box: Year(Date), Month box: Month(Date), Day box: Day(Date).
-->BAR Graph should be created based on product type (under dimension tab) and count(phone_number) under expresssions tab.
Here i want to create a comparision graph. where user can select single/multiple years, months and Days. (there should be two bars for each product type)
Year || Month || Date
------
Y1 Y2| M1 M2| D1 --> 1st bar should give count(phone_number) for Y1M1D1 and 2nd bar should give count(phone_number) for Y2M2D1
Y1 Y2 | M1 | D1 D2 --> 1st bar should give count(phone_number) for Y1M1D1 and 2nd bar should give count(phone_number) for Y2M1D1
Y1 | M1 M2 | D1 D2 -->1st bar should give count(phone_number) for Y1M1D1 and 2nd bar should give count(phone_number) for Y1M2D2
-----
Y1 Y2 Y3 | M1 | D1 -->1st bar should give average(phone_number) for Y1-Y2 M1D1 and 2nd bar should give count(phone_number) for Y3M1D1
Y1 Y2 Y3 | M1 M2| D1 D2 -->1st bar should give average(phone_number) for Y1-Y2 M1D1 and 2nd bar should give count(phone_number) for Y3M2D2.
Y1 Y2 Y3 | M1 M2 M3| D1 D2 D3 -->1st bar should give average(phone_number) for (Y1-Y2)(M1-M2)(D1-D2) and 2nd bar should give count(phone_number) for Y3M3D3.
if no selection for any box: by default it should consider current year/month/day.
