topic Re: Pivot table row percentages in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-row-percentages/m-p/1351755#M834558 <HTML><HEAD></HEAD><BODY><P>create a variable to store the Actual Dimension names that the use select</P><P></P><P>and then pass that variable to with AGGR()</P><P></P><P>example</P><P></P><P>SUM( AGGR( SUM( Expression ) ,&nbsp; $(ListofFields) )</P><P></P><P></P><P>where $(ListofFields) = comma separated fieldnames as STRING.</P></BODY></HTML> Mon, 29 May 2017 10:19:49 GMT vinieme12 2017-05-29T10:19:49Z Pivot table row percentages https://community.qlik.com/t5/QlikView/Pivot-table-row-percentages/m-p/1351754#M834557 <HTML><HEAD></HEAD><BODY><P>Hoping someone may be able to help...</P><P></P><P>I've built fully customisable straight a pivot tables where the users can specify the visible dimensions as well as the displayed expression (Using variables to display conditional dimensions and expressions). Whilst I've also managed to add column percentages, I haven't found a way to add row percentages without specifying the dimensions statically. <SPAN style="font-size: 13.3333px;">This approach isn't practical as the users have 40+ dimensions to choose from. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>For example, if the user selects faculty and gender, I want them to be able to see a proportion spread totalling 100% for each faculty (or whichever other two dimensions they choose).</P><P></P><P>Does anyone have any ideas how I might be able to go about this?</P><P></P><P>Appreciated.</P><P></P><P>Matt</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-row-percentages/m-p/1351754#M834557 mattphillip 2020-11-25T16:16:04Z Re: Pivot table row percentages https://community.qlik.com/t5/QlikView/Pivot-table-row-percentages/m-p/1351755#M834558 <HTML><HEAD></HEAD><BODY><P>create a variable to store the Actual Dimension names that the use select</P><P></P><P>and then pass that variable to with AGGR()</P><P></P><P>example</P><P></P><P>SUM( AGGR( SUM( Expression ) ,&nbsp; $(ListofFields) )</P><P></P><P></P><P>where $(ListofFields) = comma separated fieldnames as STRING.</P></BODY></HTML> Mon, 29 May 2017 10:19:49 GMT https://community.qlik.com/t5/QlikView/Pivot-table-row-percentages/m-p/1351755#M834558 vinieme12 2017-05-29T10:19:49Z