How to create a single comparision graph for different Date ranges?

abhilash92 — Thu, 20 Sep 2018 09:29:27 GMT

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.

topic How to create a single comparision graph for different Date ranges? in QlikView

How to create a single comparision graph for different Date ranges?