Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

How to show result for selection in dimensions.

Dear All!
Please, help me to solve the issue.

I have several Dimension, in the example, there is _AAA and _DDD. And I have the text object to show what particular dimension has the selections. If the selection only in _AAA  in the text object should be "A". And if the selections in _AAAand _DDD or in _DDD only it should be "D".

The issue is that I don't understand how to create a condition in the text object to get "D" as the result. I tried to use if-statement and GetSelectedCount(). But it is enough only to get "A" answer. 

Labels (2)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try this:

=if(GetSelectedCount(_DDD)>0, 'D', (If(GetSelectedCount(_AAA)>0,'A')))

View solution in original post

2 Replies
tresesco
MVP
MVP

Try this:

=if(GetSelectedCount(_DDD)>0, 'D', (If(GetSelectedCount(_AAA)>0,'A')))
Peony
Creator III
Creator III
Author

Works perfectly! Thank you!