topic drill down in bar chart in QlikView

drill down in bar chart

aniketsr — Sun, 03 May 2020 06:52:30 GMT

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.

Re: drill down in bar chart

agni_gold — Sun, 03 May 2020 10:12:03 GMT

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

Re: drill down in bar chart

Brett_Bleess — Wed, 27 May 2020 11:07:14 GMT

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