Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Only show dimension values where expression value exists

I have a bar chart with year as the dimension, and my calendar table has dates from 2000-2012. I have two expressions, number of calls and change per year, but I only have measurements for calls since 2004, so I would like to only show the years with measurements, i.e. 2004-2012. If I remove the second expressions, only 2004-2012 are shown, but when I have both expressions, 2000-2012 are shown with no values for the first four years. How can I remove years without measurements when I have two expressions?

The values for the second expressions does not have its own bars, but are shown on top of the first expressions bars.

2 Replies
Not applicable
Author

you could try.   if('Expression1'>0 and 'Expression2'>0,Date,'-') as a dimension (supress null values)  Regards  RL

Not applicable
Author

Thanks, but it made no difference.