topic Re: Displaying data: How do I show where multiple instances have occurred? in App Development https://community.qlik.com/t5/App-Development/Displaying-data-How-do-I-show-where-multiple-instances-have/m-p/794916#M11073 <HTML><HEAD></HEAD><BODY><P>This was posted on a similar thread and I believe it worked. Still verifying.</P><P></P><P>count({&lt;[Flavor]={"=count(distinct [Shop Location])&gt;1"}&gt;}distinct [Flavor])</P></BODY></HTML> Fri, 13 Mar 2015 16:24:48 GMT 2015-03-13T16:24:48Z Displaying data: How do I show where multiple instances have occurred? https://community.qlik.com/t5/App-Development/Displaying-data-How-do-I-show-where-multiple-instances-have/m-p/794915#M11072 <HTML><HEAD></HEAD><BODY><P>Example:</P><P></P><P>I have 10 Ice Cream shops.</P><P>I have multiple flavors at all the stores.</P><P>I want to show how many of the same flavors I have at the stores at any given moment.</P><P></P><P>Data I have:</P><P>1. Shop locations</P><P>2. Flavors</P><P></P><P>How do I visualize this? I'm brain-fried.</P></BODY></HTML> Fri, 13 Mar 2015 00:07:13 GMT https://community.qlik.com/t5/App-Development/Displaying-data-How-do-I-show-where-multiple-instances-have/m-p/794915#M11072 2015-03-13T00:07:13Z Re: Displaying data: How do I show where multiple instances have occurred? https://community.qlik.com/t5/App-Development/Displaying-data-How-do-I-show-where-multiple-instances-have/m-p/794916#M11073 <HTML><HEAD></HEAD><BODY><P>This was posted on a similar thread and I believe it worked. Still verifying.</P><P></P><P>count({&lt;[Flavor]={"=count(distinct [Shop Location])&gt;1"}&gt;}distinct [Flavor])</P></BODY></HTML> Fri, 13 Mar 2015 16:24:48 GMT https://community.qlik.com/t5/App-Development/Displaying-data-How-do-I-show-where-multiple-instances-have/m-p/794916#M11073 2015-03-13T16:24:48Z