Show VAR1 that appear in multiple VAR2

[#1]

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!

[Gysbert_Wassenaar · Accepted solution]

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

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

[#3]

Thank you for your help!

I'm doing this in Qlik Sense.

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

[#4]

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