Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
lanlizgu
Creator III
Creator III

Set analysis don't show data when not selected

Hi,

 

I have a KPI where I'm counting the number of stores such as 

=count(distinct {<STORE={'one'}>}ID)

The thing is that If I select a STORE different than one, I don't want the count  to take place. 

How could I achieve this without an if and just with set analysis?

 

Thank you.

 

Best regards.

1 Solution

Accepted Solutions
lanlizgu
Creator III
Creator III
Author

aggregating by the same field solves the issue:

aggr(count(distinct {<STORE={'one'}>}ID, STORE)

View solution in original post

2 Replies
rubenmarin

Hi, maybe with * operator:

=count(distinct {<STORE*={'one'}>}ID)

lanlizgu
Creator III
Creator III
Author

aggregating by the same field solves the issue:

aggr(count(distinct {<STORE={'one'}>}ID, STORE)