topic Re: Fixing percent in QlikView https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489520#M1146500 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Sum (Antall)/Sum (TOTAL Antall)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">and in number tab for this expression </SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">fixed to 2&nbsp; and check on show in % if you want otherwise Uncheck it<BR /></SPAN></P></BODY></HTML> Tue, 13 Aug 2013 11:13:49 GMT er_mohit 2013-08-13T11:13:49Z Fixing percent https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489519#M1146499 <HTML><HEAD></HEAD><BODY><P>I have a dimension which is restricted and thereby doesn't show everything.</P><P></P><P>Current formula:</P><P></P><P>Sum (Antall)/Sum (TOTAL(Antall))</P><P></P><P>However this formula yields percentage based upon every number in the dimension. Can this be adjusted so it only calculates from the shown rows?</P></BODY></HTML> Tue, 13 Aug 2013 11:07:03 GMT https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489519#M1146499 2013-08-13T11:07:03Z Re: Fixing percent https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489520#M1146500 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Sum (Antall)/Sum (TOTAL Antall)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">and in number tab for this expression </SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">fixed to 2&nbsp; and check on show in % if you want otherwise Uncheck it<BR /></SPAN></P></BODY></HTML> Tue, 13 Aug 2013 11:13:49 GMT https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489520#M1146500 er_mohit 2013-08-13T11:13:49Z Re: Fixing percent https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489521#M1146501 <HTML><HEAD></HEAD><BODY><P>Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.</P></BODY></HTML> Tue, 13 Aug 2013 11:13:58 GMT https://community.qlik.com/t5/QlikView/Fixing-percent/m-p/489521#M1146501 2013-08-13T11:13:58Z