https://community.qlik.com/t5/QlikView/How-to-create-a-chart-where-dimension-is-a-calculated-dimension/m-p/1649512#M730629 <P>I have a list of names per year for 11 years calculated and concatenated in variables (1 variable per year). I need to count how many times the names appeared in the list. So i have 0 (if the name never came up in the list) to 11 (if a name appeared on the list for every year).</P><P>I need to create a chart where the frequency (0 to 11) is the dimension and the count of names per district as the expression. See image as example</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample pic.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24134iE1BD8053DC12800E/image-size/medium?v=v2&amp;px=400" role="button" title="sample pic.png" alt="sample pic.png" /></span></P> Sat, 16 Nov 2024 01:53:29 GMT ___dl 2024-11-16T01:53:29Z https://community.qlik.com/t5/QlikView/How-to-create-a-chart-where-dimension-is-a-calculated-dimension/m-p/1649512#M730629 <P>I have a list of names per year for 11 years calculated and concatenated in variables (1 variable per year). I need to count how many times the names appeared in the list. So i have 0 (if the name never came up in the list) to 11 (if a name appeared on the list for every year).</P><P>I need to create a chart where the frequency (0 to 11) is the dimension and the count of names per district as the expression. See image as example</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample pic.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24134iE1BD8053DC12800E/image-size/medium?v=v2&amp;px=400" role="button" title="sample pic.png" alt="sample pic.png" /></span></P> Sat, 16 Nov 2024 01:53:29 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-chart-where-dimension-is-a-calculated-dimension/m-p/1649512#M730629 ___dl 2024-11-16T01:53:29Z https://community.qlik.com/t5/QlikView/How-to-create-a-chart-where-dimension-is-a-calculated-dimension/m-p/1654348#M730630 <P>Divine, in these cases, it is generally helpful if you can attach your data source, I suspect this is why you have not received anything on this one yet, as a bit difficult to offer up things without knowing the details.</P> <P>Regards,<BR />Brett</P> Wed, 04 Dec 2019 21:37:44 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-chart-where-dimension-is-a-calculated-dimension/m-p/1654348#M730630 Brett_Bleess 2019-12-04T21:37:44Z