Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Displaying data: How do I show where multiple instances have occurred?

Example:

I have 10 Ice Cream shops.

I have multiple flavors at all the stores.

I want to show how many of the same flavors I have at the stores at any given moment.

Data I have:

1. Shop locations

2. Flavors

How do I visualize this? I'm brain-fried.

1 Solution

Accepted Solutions
Not applicable

Re: Displaying data: How do I show where multiple instances have occurred?

This was posted on a similar thread and I believe it worked. Still verifying.

count({<[Flavor]={"=count(distinct [Shop Location])>1"}>}distinct [Flavor])

1 Reply
Not applicable

Re: Displaying data: How do I show where multiple instances have occurred?

This was posted on a similar thread and I believe it worked. Still verifying.

count({<[Flavor]={"=count(distinct [Shop Location])>1"}>}distinct [Flavor])