topic Re: If then else sum in QlikView https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282432#M867657 <HTML><HEAD></HEAD><BODY><P>Sum(If(Turnover*0,25 &lt; 60, 60, Turnover * 0,25))</P></BODY></HTML> Mon, 05 Dec 2016 13:03:06 GMT Gysbert_Wassenaar 2016-12-05T13:03:06Z If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282431#M867656 <HTML><HEAD></HEAD><BODY><P>I want to make a if then else sum in Qlikview that calculates</P><P></P><P>If Turnover*0,25 &lt; 60, Then 60, Else Turnover * 0,25.</P><P></P><P>Can anyone help?</P><P></P><P>Updated with Qvw. Meddelandet redigerades av: Niklas Söderqvist</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282431#M867656 2020-11-25T16:16:04Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282432#M867657 <HTML><HEAD></HEAD><BODY><P>Sum(If(Turnover*0,25 &lt; 60, 60, Turnover * 0,25))</P></BODY></HTML> Mon, 05 Dec 2016 13:03:06 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282432#M867657 Gysbert_Wassenaar 2016-12-05T13:03:06Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282433#M867658 <HTML><HEAD></HEAD><BODY><P>Hey Gysbert tried that but it jsut gives me 0 on every row.</P></BODY></HTML> Mon, 05 Dec 2016 13:06:14 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282433#M867658 2016-12-05T13:06:14Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282434#M867659 <HTML><HEAD></HEAD><BODY><P>If you look at the pic I attached you'll see</P></BODY></HTML> Mon, 05 Dec 2016 13:14:38 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282434#M867659 2016-12-05T13:14:38Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282435#M867660 <HTML><HEAD></HEAD><BODY><P>Screenshots are bloody useless. Please post something with data that can be used to reproduce the issue.</P></BODY></HTML> Mon, 05 Dec 2016 13:18:06 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282435#M867660 Gysbert_Wassenaar 2016-12-05T13:18:06Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282436#M867661 <HTML><HEAD></HEAD><BODY><P>Is turnover a field or expression here? or may be it is an expression label?</P></BODY></HTML> Mon, 05 Dec 2016 13:19:46 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282436#M867661 sunny_talwar 2016-12-05T13:19:46Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282437#M867662 <HTML><HEAD></HEAD><BODY><P>Updated with a qvw i just copied your expression</P></BODY></HTML> Mon, 05 Dec 2016 13:31:56 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282437#M867662 2016-12-05T13:31:56Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282438#M867663 <HTML><HEAD></HEAD><BODY><SPAN>Replace the label Turnover with the expression that it represents:&nbsp; Sum(If(price*volume*0.0025&lt;60, 60, price*volume * 0.0025))</SPAN></BODY></HTML> Mon, 05 Dec 2016 13:34:54 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282438#M867663 Gysbert_Wassenaar 2016-12-05T13:34:54Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282439#M867664 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum(Aggr(If(sum(price*volume)*0.0025 &lt; 60, 60, sum(price*volume) * 0.0025), orderId, longName, buySell))</STRONG></P></BODY></HTML> Mon, 05 Dec 2016 13:35:51 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282439#M867664 sunny_talwar 2016-12-05T13:35:51Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282440#M867665 <HTML><HEAD></HEAD><BODY><P>Yeah that worked! thanks man!</P><P></P><P>Problem was I used label of the expression instead of the expression it represented! </P><P></P><P>Cheers!</P></BODY></HTML> Mon, 05 Dec 2016 13:39:14 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282440#M867665 2016-12-05T13:39:14Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282441#M867666 <HTML><HEAD></HEAD><BODY><P>Hey Sunny that actuallt worked better got some issues with the previous response. Can you explain to me what your expression is doing?</P></BODY></HTML> Mon, 05 Dec 2016 14:54:27 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282441#M867666 2016-12-05T14:54:27Z Re: If then else sum https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282442#M867667 <HTML><HEAD></HEAD><BODY><P>I am just using your exact expression which you had under Turnover. This was aggregated expression vs. <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">price*volume</STRONG> which was unaggregated. But the issue was that since you have an aggregation within an aggregation, you need to use Aggr() function.</P><P></P><P>You can check this link out for more on Aggr() function</P><P><A href="https://www.analyticsvidhya.com/blog/2014/02/aggr/" title="https://www.analyticsvidhya.com/blog/2014/02/aggr/">https://www.analyticsvidhya.com/blog/2014/02/aggr/</A></P></BODY></HTML> Mon, 05 Dec 2016 15:06:38 GMT https://community.qlik.com/t5/QlikView/If-then-else-sum/m-p/1282442#M867667 sunny_talwar 2016-12-05T15:06:38Z