Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Only show dimension values where expression value exists

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

Not applicable

Re: Only show dimension values where expression value exists

Thanks, but it made no difference.

Community Browser