https://community.qlik.com/t5/App-Development/Calculate-ratio-with-text-values/m-p/1599367#M44313 <P>Hi all, I've got a question regarding calculating percentages over textual data. Lets take the sample data given below (fake_data_speerpnt.xlsx).&nbsp;</P><P>I want to determine the ratio of text occuring for each location at a certain year, preferably also aligned with the name. As an example see the image.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dataset sample" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14970i0BCD5D27CE206B98/image-size/medium?v=v2&amp;px=400" role="button" title="ratio_dataset.PNG" alt="Dataset sample" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Dataset sample</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ratio calculation" style="width: 614px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14971iF353CEDBE6AB697F/image-dimensions/614x130?v=v2" width="614" height="130" role="button" title="ratio_calc.PNG" alt="Ratio calculation" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Ratio calculation</span></span></P><P>Using Count(total &lt;Location&gt; Agreement1) gives me the output based on location selection. However, when I want to determine the ratio, so the full expression will be Count(total &lt;Location&gt; Agreement1) / Count(total Agreement1). The result however does not return the ratio.</P><P>The outcome should be presented in a pivot table.&nbsp;</P> Sat, 16 Nov 2024 20:30:52 GMT klikgevoel 2024-11-16T20:30:52Z https://community.qlik.com/t5/App-Development/Calculate-ratio-with-text-values/m-p/1599367#M44313 <P>Hi all, I've got a question regarding calculating percentages over textual data. Lets take the sample data given below (fake_data_speerpnt.xlsx).&nbsp;</P><P>I want to determine the ratio of text occuring for each location at a certain year, preferably also aligned with the name. As an example see the image.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dataset sample" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14970i0BCD5D27CE206B98/image-size/medium?v=v2&amp;px=400" role="button" title="ratio_dataset.PNG" alt="Dataset sample" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Dataset sample</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ratio calculation" style="width: 614px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14971iF353CEDBE6AB697F/image-dimensions/614x130?v=v2" width="614" height="130" role="button" title="ratio_calc.PNG" alt="Ratio calculation" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Ratio calculation</span></span></P><P>Using Count(total &lt;Location&gt; Agreement1) gives me the output based on location selection. However, when I want to determine the ratio, so the full expression will be Count(total &lt;Location&gt; Agreement1) / Count(total Agreement1). The result however does not return the ratio.</P><P>The outcome should be presented in a pivot table.&nbsp;</P> Sat, 16 Nov 2024 20:30:52 GMT https://community.qlik.com/t5/App-Development/Calculate-ratio-with-text-values/m-p/1599367#M44313 klikgevoel 2024-11-16T20:30:52Z