If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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.
Your model look very nice.
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.
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.