Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniketsr
Creator
Creator

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.

2 Replies
agni_gold
Specialist III
Specialist III

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

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.