drill down in bar chart

[aniketsr]

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.

[agni_gold]

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

[Brett_Bleess]

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