Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.