Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
msmSahaj
Contributor III
Contributor III

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

 

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-MonthLast WeekLast MonthLast Year
2014-12nonoyes
2014-12nonoyes
2014-12nonoyes
2014-12nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-10nonoyes
2014-10yesyesyes
2014-10nonoyes
2014-10noyesyes
2015-01yesyesyes
2015-01yesyesyes
2015-01nonoyes
 
 Please help with this...
Thanks,
sahaj 
Labels (1)
14 Replies
Vegar
MVP
MVP

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
MVP
MVP

Your model look very nice. 

msmSahaj
Contributor III
Contributor III
Author

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.

1.PNG

Vegar
MVP
MVP

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

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.

 

 

 

 

Capture.PNG