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: 
Not applicable

Show VAR1 that appear in multiple VAR2

Please help, I can't figure out how to visualize this in Qlik Sense.

I need to show all of the VAR1 that appear at >1 VAR2

In an example:

VAR1 = flavors of ice cream

VAR2 = store locations

I need to show all of the flavors that appear at more than 1 store location, and count the number of flavors.

thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this maybe: count({<VAR1={"=count(distinct VAR2)>1"}>}distinct VAR1)

If not please post a qlikview document with some relevant example data.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Something like this maybe: count({<VAR1={"=count(distinct VAR2)>1"}>}distinct VAR1)

If not please post a qlikview document with some relevant example data.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you for your help!

I'm doing this in Qlik Sense.

The formula above seems to have worked. I am verifying.

Not applicable
Author

Gysbert, that worked perfectly! Do you know of a way to show a list of those VAR2 items?