topic Re: aggr function in QlikView https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705108#M451425 <P>Hi,</P><P>Can you not do this without AGGR, say;</P><P><FONT>Sum(Value)/sum(TOTAL &lt;Date, User&gt; Value)</FONT></P><P><FONT>Cheers,</FONT></P><P><FONT>Chris.</FONT></P> Tue, 26 May 2020 09:13:35 GMT chrismarlow 2020-05-26T09:13:35Z aggr function https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705099#M451422 <P>Hi everyone,</P><P>I hope you are fine:)</P><P>Can you help me with this formula(Type%-column)</P><P>How can I find the percentage distribution of Type Values according to the Aggr column?</P><P>regards..</P><TABLE width="923"><TBODY><TR><TD width="76">Date</TD><TD width="64">User</TD><TD width="64">Type</TD><TD width="40">Value</TD><TD width="64"><STRONG>Aggr</STRONG></TD><TD width="173">Aggr-Formula</TD><TD width="64"><STRONG>Type%</STRONG></TD><TD width="378">Type%-Formula?</TD></TR><TR><TD>01/05/2020</TD><TD>U1</TD><TD>T1</TD><TD>200</TD><TD>900</TD><TD>Aggr( sum(Value),Date,User)</TD><TD><STRONG>22%</STRONG></TD><TD>Aggr( sum(Value),Date,User,Type)/Aggr( sum(Value),Date,User)</TD></TR><TR><TD>01/05/2020</TD><TD>U1</TD><TD>T2</TD><TD>300</TD><TD>900</TD><TD>&nbsp;</TD><TD><STRONG>33%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>01/05/2020</TD><TD>U1</TD><TD>T3</TD><TD>400</TD><TD>900</TD><TD>&nbsp;</TD><TD><STRONG>44%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>01/05/2020</TD><TD>U2</TD><TD>T1</TD><TD>200</TD><TD>700</TD><TD>&nbsp;</TD><TD><STRONG>29%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>01/05/2020</TD><TD>U2</TD><TD>T2</TD><TD>200</TD><TD>700</TD><TD>&nbsp;</TD><TD><STRONG>29%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>01/05/2020</TD><TD>U2</TD><TD>T3</TD><TD>300</TD><TD>700</TD><TD>&nbsp;</TD><TD><STRONG>43%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U1</TD><TD>T1</TD><TD>500</TD><TD>1000</TD><TD>&nbsp;</TD><TD><STRONG>50%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U1</TD><TD>T2</TD><TD>200</TD><TD>1000</TD><TD>&nbsp;</TD><TD><STRONG>20%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U1</TD><TD>T3</TD><TD>300</TD><TD>1000</TD><TD>&nbsp;</TD><TD><STRONG>30%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U2</TD><TD>T1</TD><TD>150</TD><TD>650</TD><TD>&nbsp;</TD><TD><STRONG>23%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U2</TD><TD>T2</TD><TD>200</TD><TD>650</TD><TD>&nbsp;</TD><TD><STRONG>31%</STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>02/05/2020</TD><TD>U2</TD><TD>T3</TD><TD>300</TD><TD>650</TD><TD>&nbsp;</TD><TD><STRONG>46%</STRONG></TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 18:35:29 GMT https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705099#M451422 mert1917 2024-11-16T18:35:29Z Re: aggr function https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705108#M451425 <P>Hi,</P><P>Can you not do this without AGGR, say;</P><P><FONT>Sum(Value)/sum(TOTAL &lt;Date, User&gt; Value)</FONT></P><P><FONT>Cheers,</FONT></P><P><FONT>Chris.</FONT></P> Tue, 26 May 2020 09:13:35 GMT https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705108#M451425 chrismarlow 2020-05-26T09:13:35Z Re: aggr function https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705146#M451429 <P>Yess Thats great thank you Chris<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P><P>regards&nbsp;</P> Tue, 26 May 2020 10:44:12 GMT https://community.qlik.com/t5/QlikView/aggr-function/m-p/1705146#M451429 mert1917 2020-05-26T10:44:12Z