Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Cross Table Show where one occurence

Right now, my chart based on the cross table shows every ORDER_VV where the dimensions are the same. I want to ONLY show items where there is only one occurrence at 1 ORDER_VV.

For example: The only item in this DESCRIPTION that only occurs at 1 ORDER_VV is the following so I would ONLY want to see it and the ORDER_VV of SMLB.

Something with conditional using getselectedcount maybe?

8-23-2017 2-38-38 PM.jpg

TIA!

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(Count(TOTAL <DESCRIPTION, NOTE, ORDERABLE, ORDER_SENTENCE, PRECHECKED, DOMAIN> ORDER_VV) = 1, Count(ORDER_VV))

View solution in original post

2 Replies
sunny_talwar

May be this

If(Count(TOTAL <DESCRIPTION, NOTE, ORDERABLE, ORDER_SENTENCE, PRECHECKED, DOMAIN> ORDER_VV) = 1, Count(ORDER_VV))

cbaqir
Specialist II
Specialist II
Author

Thank you!