topic AGGR Problem COMPARISON in QlikView https://community.qlik.com/t5/QlikView/AGGR-Problem-COMPARISON/m-p/743581#M1030592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>As I know, Qlikview permits to operate with 2 aggr expresions, for example:</P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78426_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>So, QV will sum the 1st expresion + the 2nd expresion for each "Grup" dimension. That's perfect!</P><P></P><P><STRONG style="font-size: 14pt;">But, </STRONG><SPAN style="font-size: 10pt;">t</SPAN><SPAN style="font-size: 10pt;">he problem appears when we want to compare both aggr, for example:</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/78427_pastedImage_4.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P>Here, QV only compares the first group of the dimension called "Grup" and applies the result for all the other "Grup" values. So, QV does not do the comparison for&nbsp; every single "Grup" value.</P><P></P><P><SPAN style="font-size: 12pt;"><STRONG>Do you know any other way to compare 2 aggr?</STRONG></SPAN></P><P></P><P>Thank you in advance!!!</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z AGGR Problem COMPARISON https://community.qlik.com/t5/QlikView/AGGR-Problem-COMPARISON/m-p/743581#M1030592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>As I know, Qlikview permits to operate with 2 aggr expresions, for example:</P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78426_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>So, QV will sum the 1st expresion + the 2nd expresion for each "Grup" dimension. That's perfect!</P><P></P><P><STRONG style="font-size: 14pt;">But, </STRONG><SPAN style="font-size: 10pt;">t</SPAN><SPAN style="font-size: 10pt;">he problem appears when we want to compare both aggr, for example:</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/78427_pastedImage_4.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P>Here, QV only compares the first group of the dimension called "Grup" and applies the result for all the other "Grup" values. So, QV does not do the comparison for&nbsp; every single "Grup" value.</P><P></P><P><SPAN style="font-size: 12pt;"><STRONG>Do you know any other way to compare 2 aggr?</STRONG></SPAN></P><P></P><P>Thank you in advance!!!</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/AGGR-Problem-COMPARISON/m-p/743581#M1030592 2020-11-20T18:02:30Z