Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
whalenem
Contributor II
Contributor II

Calculated dimension not returning all values

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...

CategoryDivisionSales
A1100

B

1
C1100
D2100
E2

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.

3 Replies
aarkay29
Specialist
Specialist

Try this

Go to the chart properties and include null values

whalenem
Contributor II
Contributor II
Author

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

2018-10-03 14_05_57-QV QA - duqlkq2.ad.bigrocksports.com - Remote Desktop Connection.png2018-10-03 14_04_45-QV QA - duqlkq2.ad.bigrocksports.com - Remote Desktop Connection.png

aarkay29
Specialist
Specialist

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