topic Re: Only show dimension values where expression value exists in QlikView https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345458#M1171784 <HTML><HEAD></HEAD><BODY><P>you could try.&nbsp;&nbsp; if('Expression1'&gt;0 and 'Expression2'&gt;0,Date,'-') as a dimension (supress null values)&nbsp; Regards&nbsp; RL</P></BODY></HTML> Wed, 11 Jul 2012 11:47:24 GMT 2012-07-11T11:47:24Z Only show dimension values where expression value exists https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345457#M1171783 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>The values for the second expressions does not have its own bars, but are shown on top of the first expressions bars.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345457#M1171783 2020-11-20T18:02:30Z Re: Only show dimension values where expression value exists https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345458#M1171784 <HTML><HEAD></HEAD><BODY><P>you could try.&nbsp;&nbsp; if('Expression1'&gt;0 and 'Expression2'&gt;0,Date,'-') as a dimension (supress null values)&nbsp; Regards&nbsp; RL</P></BODY></HTML> Wed, 11 Jul 2012 11:47:24 GMT https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345458#M1171784 2012-07-11T11:47:24Z Re: Only show dimension values where expression value exists https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345459#M1171785 <HTML><HEAD></HEAD><BODY><P>Thanks, but it made no difference.</P></BODY></HTML> Wed, 11 Jul 2012 14:39:11 GMT https://community.qlik.com/t5/QlikView/Only-show-dimension-values-where-expression-value-exists/m-p/345459#M1171785 2012-07-11T14:39:11Z