topic Re: Total and if statement in QlikView https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417739#M615220 <HTML><HEAD></HEAD><BODY><P>Hi, can you explain the issue? Maybe you want "Sum(F2) - 1" (the -1 outside parenthesys) for Diff?</P><P></P><P>Edit: Ok, thanks Sunny.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 17 Aug 2017 11:50:38 GMT rubenmarin 2017-08-17T11:50:38Z Total and if statement https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417736#M615217 <HTML><HEAD></HEAD><BODY><P>Hei,</P><P></P><P>I faced a little issue:</P><P><IMG __jive_id="173696" alt="Screenshot_2.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173696_Screenshot_2.jpg" style="height: auto;" /></P><P></P><P>I've attached also and the test.qvd.</P><P></P><P>Could you help me?</P><P></P><P>Thank you!</P></BODY></HTML> Thu, 17 Aug 2017 11:45:42 GMT https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417736#M615217 MindaugasBacius 2017-08-17T11:45:42Z Re: Total and if statement https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417737#M615218 <HTML><HEAD></HEAD><BODY><P>May be use Sum of rows if this is a straight table like your sample</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173692_Capture.PNG" style="height: 239px; width: 620px;" /></P></BODY></HTML> Thu, 17 Aug 2017 11:48:11 GMT https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417737#M615218 sunny_talwar 2017-08-17T11:48:11Z Re: Total and if statement https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417738#M615219 <HTML><HEAD></HEAD><BODY><P>Or use this</P><P></P><P><STRONG>Sum(Aggr(If(Sum(F2 - 1)/Sum(F2)&lt;=0.5, Sum(F2), Sum(F2 - 1)), A, F2))</STRONG></P></BODY></HTML> Thu, 17 Aug 2017 11:49:52 GMT https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417738#M615219 sunny_talwar 2017-08-17T11:49:52Z Re: Total and if statement https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417739#M615220 <HTML><HEAD></HEAD><BODY><P>Hi, can you explain the issue? Maybe you want "Sum(F2) - 1" (the -1 outside parenthesys) for Diff?</P><P></P><P>Edit: Ok, thanks Sunny.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 17 Aug 2017 11:50:38 GMT https://community.qlik.com/t5/QlikView/Total-and-if-statement/m-p/1417739#M615220 rubenmarin 2017-08-17T11:50:38Z