https://community.qlik.com/t5/QlikView/Using-set-analysis-to-create-a-percentage/m-p/1709704#M591770 <P>Hi,&nbsp;</P><P>I have used the following set analysis as an expression to create the total FTE for a specific year against a dimension (e.g. gender) in a pivot table: sum({$&lt;[ACYEAR]={"2018/19"}&gt;}[FTE]).</P><P>I would now like to convert this number into a percentage i.e. total FTE of a gender for 2018/19 / total FTE for 2018/19 * 100.&nbsp;</P><P>Can anyone help on this please? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>Many thanks</P><P>Dilpreet</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:30:15 GMT gilldilpreet 2024-11-16T00:30:15Z https://community.qlik.com/t5/QlikView/Using-set-analysis-to-create-a-percentage/m-p/1709704#M591770 <P>Hi,&nbsp;</P><P>I have used the following set analysis as an expression to create the total FTE for a specific year against a dimension (e.g. gender) in a pivot table: sum({$&lt;[ACYEAR]={"2018/19"}&gt;}[FTE]).</P><P>I would now like to convert this number into a percentage i.e. total FTE of a gender for 2018/19 / total FTE for 2018/19 * 100.&nbsp;</P><P>Can anyone help on this please? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>Many thanks</P><P>Dilpreet</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:30:15 GMT https://community.qlik.com/t5/QlikView/Using-set-analysis-to-create-a-percentage/m-p/1709704#M591770 gilldilpreet 2024-11-16T00:30:15Z https://community.qlik.com/t5/QlikView/Using-set-analysis-to-create-a-percentage/m-p/1709708#M591771 <P>use</P><P><SPAN>sum({$&lt;[ACYEAR]={"2018/19"}&gt;}[FTE])</SPAN></P><P><SPAN>/&nbsp;sum({$&lt;[ACYEAR]={"2018/19"}&gt;}total [FTE]) *100</SPAN></P><P><SPAN>Regards</SPAN></P> Wed, 10 Jun 2020 11:45:30 GMT https://community.qlik.com/t5/QlikView/Using-set-analysis-to-create-a-percentage/m-p/1709708#M591771 martinpohl 2020-06-10T11:45:30Z