topic Re: MAX of Sum IF expression in QlikView https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627505#M1091216 <HTML><HEAD></HEAD><BODY><P>Ok, must be something with my local settings.</P><P>Thanks!</P></BODY></HTML> Mon, 26 May 2014 13:21:03 GMT 2014-05-26T13:21:03Z MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627498#M1091209 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm new to QV and I'm trying to figure out how to write an expression calculating the the maximum of a SUMIF expression, without any luck.</P><P></P><P>For a certain range of dates I need to present the three largest positive and negative values (gross sent and gross received).</P><P></P><P>For instance, I would like to choose a month and then present the three largest daily sums. I guess what Im lookin for is some kind of aggregated function but I can't seem to get it right.</P><P></P><P>Any ideas?</P><P>Pls see examples attached.</P><P></P><P>Kind Regards,</P><P>Olle&nbsp;&nbsp; </P></BODY></HTML> Mon, 26 May 2014 09:25:04 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627498#M1091209 2014-05-26T09:25:04Z Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627499#M1091210 <HTML><HEAD></HEAD><BODY><P>Hi Olle,</P><P></P><P>check my example</P></BODY></HTML> Mon, 26 May 2014 09:48:01 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627499#M1091210 2014-05-26T09:48:01Z Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627500#M1091211 <HTML><HEAD></HEAD><BODY><P>Thank you for your answer Dariusz,</P><P></P><P>however. My problem is that I first need to summarize the negative and positive values (separately) for each date selected. As per below:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="font-size: 8pt;">SUM(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionAmount</SPAN><SPAN style="font-size: 8pt;">&lt;0,</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionAmount</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="font-size: 8pt;">SUM(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionAmount&gt;</SPAN><SPAN style="font-size: 8pt;">0,</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionAmount</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;">After this is done, I need present the three largest/smallest <STRONG>sums.</STRONG></SPAN></P><P> </P><P><SPAN style="font-size: 8pt;"><STRONG>Thanks in advance,</STRONG></SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG>Olle </STRONG></SPAN></P></BODY></HTML> Mon, 26 May 2014 10:12:16 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627500#M1091211 2014-05-26T10:12:16Z Re: Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627501#M1091212 <HTML><HEAD></HEAD><BODY><P>try this:</P></BODY></HTML> Mon, 26 May 2014 11:33:25 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627501#M1091212 2014-05-26T11:33:25Z Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627502#M1091213 <HTML><HEAD></HEAD><BODY><P>Perfect.</P><P>Thanks a lot for your help Dariusz!</P><P></P><P>Regards,</P><P>Olle</P></BODY></HTML> Mon, 26 May 2014 11:55:32 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627502#M1091213 2014-05-26T11:55:32Z Re: Re: Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627503#M1091214 <HTML><HEAD></HEAD><BODY><P>Hi again,</P><P></P><P>Im pretty sure it worked just fine at first.</P><P>Then something happened, now when I open the qvf-file you attached above the min column always shows the same value as rank 1 &amp; 2. Do you know what might have happened? I even restarted my computer and then downloaded the file from here again.</P><P></P><P>Pls find attached.</P><P></P><P>Rgds,</P><P>Olle</P></BODY></HTML> Mon, 26 May 2014 13:00:03 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627503#M1091214 2014-05-26T13:00:03Z Re: Re: Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627504#M1091215 <HTML><HEAD></HEAD><BODY><P>I opened your attachment and i can see:</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/59542_pastedImage_0.png" style="width: 620px; height: 388px;" /></P></BODY></HTML> Mon, 26 May 2014 13:12:26 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627504#M1091215 2014-05-26T13:12:26Z Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627505#M1091216 <HTML><HEAD></HEAD><BODY><P>Ok, must be something with my local settings.</P><P>Thanks!</P></BODY></HTML> Mon, 26 May 2014 13:21:03 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627505#M1091216 2014-05-26T13:21:03Z Re: MAX of Sum IF expression https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627506#M1091217 <HTML><HEAD></HEAD><BODY><P>Strange .... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Check again and let me know</P></BODY></HTML> Mon, 26 May 2014 13:32:24 GMT https://community.qlik.com/t5/QlikView/MAX-of-Sum-IF-expression/m-p/627506#M1091217 2014-05-26T13:32:24Z