topic Re: Total in QlikView https://community.qlik.com/t5/QlikView/Total/m-p/1000714#M527793 <HTML><HEAD></HEAD><BODY><P>Ideas could be directed to the right direction, if you could attach your sample qvw.</P></BODY></HTML> Tue, 22 Sep 2015 11:41:06 GMT tresB 2015-09-22T11:41:06Z Total https://community.qlik.com/t5/QlikView/Total/m-p/1000712#M527791 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi All,</SPAN></P><P><SPAN style="font-size: 12pt;">I'm trying to calculate relative amount (pivot table) with excluded dimension :</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">(</SPAN></SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #800000;">amount</SPAN>) / <SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #0000ff;">TOTAL</SPAN> &lt;<SPAN style="color: #800000;">item_name</SPAN>&gt; <SPAN style="color: #800000;">amount</SPAN>) </SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;">but result comes as :</SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">sum</SPAN>((<SPAN style="color: #800000;">amount</SPAN>)/<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #0000ff;">TOTAL</SPAN> <SPAN style="color: #800000;">amount</SPAN>) </SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">any ideas?</SPAN></P><P></P><P></P><P> </P><P></P><P></P><P><BR /> </P></BODY></HTML> Tue, 22 Sep 2015 11:02:16 GMT https://community.qlik.com/t5/QlikView/Total/m-p/1000712#M527791 ilanbaruch 2015-09-22T11:02:16Z Re: Total https://community.qlik.com/t5/QlikView/Total/m-p/1000713#M527792 <HTML><HEAD></HEAD><BODY><P>try</P><P>aggr(<SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">sum</SPAN>((<SPAN style="color: #800000;">amount</SPAN>)/<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #0000ff;">TOTAL</SPAN> <SPAN style="color: #800000;">amount</SPAN>) ,yourdimension)</SPAN></P></BODY></HTML> Tue, 22 Sep 2015 11:07:11 GMT https://community.qlik.com/t5/QlikView/Total/m-p/1000713#M527792 sasiparupudi1 2015-09-22T11:07:11Z Re: Total https://community.qlik.com/t5/QlikView/Total/m-p/1000714#M527793 <HTML><HEAD></HEAD><BODY><P>Ideas could be directed to the right direction, if you could attach your sample qvw.</P></BODY></HTML> Tue, 22 Sep 2015 11:41:06 GMT https://community.qlik.com/t5/QlikView/Total/m-p/1000714#M527793 tresB 2015-09-22T11:41:06Z