- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
drill down in bar chart
Hi,
I have a bar chart with dimension year and month.
For Year month a drill down has been created .
when we select a year it gets drilled to those months and the user can see all the months for for the selected year.
but the requirement is along with those associated month the non selected year should also be displayed.
Eg:- Suppose i have selected 2020 so it will show Bars for JAN , FEB,MAR,APR AND 2018 AND 2019.
Attached is the application for reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create one more field in script with below condition and use that in your drill-down dimension.
if(Year (Date) = Year(Today()) , Month(Date) , Year(Date)) as Month_Drill
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Another option would be to look at using Set Analysis to display the other years, here is a Design Blog post that should allow you to check that option out in further detail:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.