topic Percentage in simple table in QlikView https://community.qlik.com/t5/QlikView/Percentage-in-simple-table/m-p/552823#M206550 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I need to calculate the percentage of every line (Key %) over the total of 'Key Vir', for example 315.11/709935.</P><P>I use the expresion <STRONG>$(vFinanceKeyVirMain)/sum(Total $(vFinanceKeyVirMain)) </STRONG>where vFinanceKeyVirMain is the value of 'Key Vir' for each line and it is calculate with <STRONG>sum({$&lt;[Invoice Date num]={'&gt;=$(vDateMin)&lt;=$(vDateMax)'},[Transaction Type Main]={'Online'}&gt;}[Total value])</STRONG> expression (that it works fine), but unfortunally it doesn't works as you can see in the image.</P><P></P><P>Any idea?</P><P>Thanks in advance.</P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 02 Aug 2013 10:06:47 GMT 2013-08-02T10:06:47Z Percentage in simple table https://community.qlik.com/t5/QlikView/Percentage-in-simple-table/m-p/552823#M206550 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I need to calculate the percentage of every line (Key %) over the total of 'Key Vir', for example 315.11/709935.</P><P>I use the expresion <STRONG>$(vFinanceKeyVirMain)/sum(Total $(vFinanceKeyVirMain)) </STRONG>where vFinanceKeyVirMain is the value of 'Key Vir' for each line and it is calculate with <STRONG>sum({$&lt;[Invoice Date num]={'&gt;=$(vDateMin)&lt;=$(vDateMax)'},[Transaction Type Main]={'Online'}&gt;}[Total value])</STRONG> expression (that it works fine), but unfortunally it doesn't works as you can see in the image.</P><P></P><P>Any idea?</P><P>Thanks in advance.</P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 02 Aug 2013 10:06:47 GMT https://community.qlik.com/t5/QlikView/Percentage-in-simple-table/m-p/552823#M206550 2013-08-02T10:06:47Z