Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Show VAR1 that appear in multiple VAR2

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
3 Replies

Re: Show VAR1 that appear in multiple VAR2

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

Re: Show VAR1 that appear in multiple VAR2

Thank you for your help!

I'm doing this in Qlik Sense.

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

Not applicable

Re: Show VAR1 that appear in multiple VAR2

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

Community Browser