Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

0 Replies