topic Calculated dimension not returning all values in QlikView

Calculated dimension not returning all values

whalenem — Wed, 03 Oct 2018 16:46:31 GMT

So, I have a need to show all values for a Division of a Category, regardless of sales. Say my data set looks like the below...

Category	Division	Sales
A	1	100
B	1
C	1	100
D	2	100
E	2

If my dimension in the cyclic is "Category", I get all five. Perfect.

If try to show all Division=1, I only show A and C - likewise with Division=2, I only get D. This is because the table is accumulating sales from items and there are no items sold. Expression: =if("Division"='1',"Category")

I want to show A, B, and C if I select Division=1 and D and E when selecting Division=2.

Re: Calculated dimension not returning all values

aarkay29 — Wed, 03 Oct 2018 16:52:56 GMT

Try this

Go to the chart properties and include null values

Re: Calculated dimension not returning all values

whalenem — Wed, 03 Oct 2018 18:08:05 GMT

That only drops the Division=2 (and Division=1 without sales) values into a [null] category, it doesn't display Category B.

Re: Calculated dimension not returning all values

aarkay29 — Wed, 03 Oct 2018 19:10:30 GMT

If you attach the qvw with sample data would be helpful to understand