topic Re: show all values on a conditional dimension? in QlikView https://community.qlik.com/t5/QlikView/show-all-values-on-a-conditional-dimension/m-p/536173#M200373 <HTML><HEAD></HEAD><BODY><P>If it works the way you want when it's expression, why not leave it there, and even put it in set analysis?</P><P></P><P>Something like:</P><P>sum({&lt;BrandCat={'Cosmetic'}&gt;}Sales)</P></BODY></HTML> Mon, 20 Jan 2014 14:41:03 GMT Nicole-Smith 2014-01-20T14:41:03Z show all values on a conditional dimension? https://community.qlik.com/t5/QlikView/show-all-values-on-a-conditional-dimension/m-p/536172#M200372 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement where I need to show all values regarding of selection logic on a conditional dimension. If I remove the condition on dimension and simply use a dimension name, show all values works great and show me all categories regardless of the selection on filters</P><P></P><P>However, If I put a little if condition to the dimension, then it wont show all null or zero data even if I select the show all values and uncheck suppress zero or null data. I need to show all categories/dimension values on the chart even if they have null or zero data within the filters that are selected.</P><P></P><P>I believe it has something to do the with the conditional dimension. Can someone please tell me how to fix this. Below is a little example of my scenario</P><P></P><P></P><P>I wanted to show all categories of brands even if they did not have any sale. It works fine if I do not use any condition on dimension.</P><P></P><P>I click on show all values and then in presentation uncheck supress missing or zero. This does exactly what I need</P><P></P><P>However, I came with a situation where I needed a condition on dimension. For example, show only brands that are from Cosmetic categories. I should show all categories from this brand even if they did not have any sale</P><P></P><P>If(BrandCat= 'Cosmetic', 'Brand') is my calculated dimension. However, this time, the chart only shows non zero and non null data. IT does not show those brands having null or zero value</P><P></P><P>Can someone please guide me how to fix this.</P><P></P><P>P.S: If I took this condition to the measure expression, then It will show all categories and brands since I am showing all values. I need to restrict dimensions to only cosmetic but then show everything in this category even if they are null or zero</P><P></P><P>Arif</P></BODY></HTML> Mon, 20 Jan 2014 10:54:52 GMT https://community.qlik.com/t5/QlikView/show-all-values-on-a-conditional-dimension/m-p/536172#M200372 2014-01-20T10:54:52Z Re: show all values on a conditional dimension? https://community.qlik.com/t5/QlikView/show-all-values-on-a-conditional-dimension/m-p/536173#M200373 <HTML><HEAD></HEAD><BODY><P>If it works the way you want when it's expression, why not leave it there, and even put it in set analysis?</P><P></P><P>Something like:</P><P>sum({&lt;BrandCat={'Cosmetic'}&gt;}Sales)</P></BODY></HTML> Mon, 20 Jan 2014 14:41:03 GMT https://community.qlik.com/t5/QlikView/show-all-values-on-a-conditional-dimension/m-p/536173#M200373 Nicole-Smith 2014-01-20T14:41:03Z