how can "on click" changes month to week and week to days in qlik sense on X axis

[msmSahaj]

Hi Experts,

Currently i have Chart based on "Year-month" column on X axis.  I need to calculated on click base on below columns(Last Week, Last Month, Last year)

       1. If chart x axis is year then by click on year should display all month.

      2. If chart x axis is month then by click any month should display weeks of that month(min 4 weeks if  3 week completed  month on this month, then previous month last week)

    3. if chart x axis is week then click on any week should display all 7 day. 

Year-Month	Last Week	Last Month	Last Year
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-10	no	no	yes
2014-10	yes	yes	yes
2014-10	no	no	yes
2014-10	no	yes	yes
2015-01	yes	yes	yes
2015-01	yes	yes	yes
2015-01	no	no	yes

 Please help with this...

Thanks,

sahaj 

Add tags

[msmSahaj]

Hi Experts,

Currently i have Chart based on "Year-month" column on X axis.  I need to calculated on click base on below columns(Last Week, Last Month, Last year)

       1. If chart x axis is year then by click on year should display all month.

      2. If chart x axis is month then by click any month should display weeks of that month(min 4 weeks if  3 week completed  month on this month, then previous month last week)

    3. if chart x axis is week then click on any week should display all 7 day. 

Year-Month	Last Week	Last Month	Last Year
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-10	no	no	yes
2014-10	yes	yes	yes
2014-10	no	no	yes
2014-10	no	yes	yes
2015-01	yes	yes	yes
2015-01	yes	yes	yes
2015-01	no	no	yes

[Vegar]

As I said earlier, Month to week drill down is a tricky one. I don't recommend using it, just because a week may belong to two diffrent months. 

Year-Quarte-Month-Day is OK

Week-weekday is OK

If you want week then I would recommend you to introduce it as an alternative dimension to your graph.

[Vegar]

Your model look very nice. 

[msmSahaj]

Hi @Vegar Thanks a lot for help and support. How to make sort for this Weeks (for eg.  49,50, 51, 52, 1,2,3,4,) I have tried sorting  from property panel not working.

[Vegar]

I looks like you've sorted by y value. Uncheck the automatic sort in properties and select numeric instead.

[msmSahaj]

Hi @Vegar, I am not able to draw ascending (in weeks, in weekdays) can you please help.

Is it have problem when i select one line of  2 Dim, 1 Measure chart to display below 1 Dim, 3 Measure chart in week and days.