topic Percentage of total in App Development https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2352#M147 <HTML><HEAD></HEAD><BODY><P>How I can have one column showing % of Total calculated in a single column. Currently, each Category has a % of Total column as show below</P><P></P><P>My dimensions are Entity and Rating</P><P>My expressions are % of Total --&gt;&nbsp; <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[AO Rating TRIM]</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Entity]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190401_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 17 Jan 2018 20:42:49 GMT Anonymous 2018-01-17T20:42:49Z Percentage of total https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2352#M147 <HTML><HEAD></HEAD><BODY><P>How I can have one column showing % of Total calculated in a single column. Currently, each Category has a % of Total column as show below</P><P></P><P>My dimensions are Entity and Rating</P><P>My expressions are % of Total --&gt;&nbsp; <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[AO Rating TRIM]</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Entity]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190401_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 17 Jan 2018 20:42:49 GMT https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2352#M147 Anonymous 2018-01-17T20:42:49Z Re: Percentage of total https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2353#M148 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Presentation Tab, select your dimensions and check Show Partial Sum option</P></BODY></HTML> Wed, 17 Jan 2018 21:47:17 GMT https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2353#M148 satishkurra 2018-01-17T21:47:17Z Re: Percentage of total https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2354#M149 <HTML><HEAD></HEAD><BODY><P>Hi Satish, when I go into presentation tab the show partial sums is greyed out and unable to edit. </P></BODY></HTML> Wed, 17 Jan 2018 22:14:54 GMT https://community.qlik.com/t5/App-Development/Percentage-of-total/m-p/2354#M149 Anonymous 2018-01-17T22:14:54Z