Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Something like this maybe: count({<VAR1={"=count(distinct VAR2)>1"}>}distinct VAR1)
If not please post a qlikview document with some relevant example data.
Something like this maybe: count({<VAR1={"=count(distinct VAR2)>1"}>}distinct VAR1)
If not please post a qlikview document with some relevant example data.
Thank you for your help!
I'm doing this in Qlik Sense.
The formula above seems to have worked. I am verifying.
Gysbert, that worked perfectly! Do you know of a way to show a list of those VAR2 items?