topic Re: How does calculation time depend on 'IF' condition in QlikView https://community.qlik.com/t5/QlikView/How-does-calculation-time-depend-on-IF-condition/m-p/1374054#M419623 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>If(FieldName = 'A', Sum(Sales), </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A1', Sum(Sales1), </SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A2', Sum(Sales2), </SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A3', Sum(Sales3)</SPAN></STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>&nbsp; )</STRONG></SPAN></P></BODY></HTML> Thu, 07 Sep 2017 15:34:07 GMT Anil_Babu_Samineni 2017-09-07T15:34:07Z How does calculation time depend on 'IF' condition https://community.qlik.com/t5/QlikView/How-does-calculation-time-depend-on-IF-condition/m-p/1374053#M419622 <HTML><HEAD></HEAD><BODY><P>How does my calculation time of a measure depend on nested 'If' statement? </P><P></P><P>I have expressions which have atleast 4 nested 'If' statements. I want to know how does calculation time depend on nested 'If'?</P></BODY></HTML> Thu, 07 Sep 2017 15:19:21 GMT https://community.qlik.com/t5/QlikView/How-does-calculation-time-depend-on-IF-condition/m-p/1374053#M419622 cena_abhishek 2017-09-07T15:19:21Z Re: How does calculation time depend on 'IF' condition https://community.qlik.com/t5/QlikView/How-does-calculation-time-depend-on-IF-condition/m-p/1374054#M419623 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>If(FieldName = 'A', Sum(Sales), </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A1', Sum(Sales1), </SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A2', Sum(Sales2), </SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="font-size: 13.3333px;">FieldName = 'A3', Sum(Sales3)</SPAN></STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><STRONG style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>&nbsp; )</STRONG></SPAN></P></BODY></HTML> Thu, 07 Sep 2017 15:34:07 GMT https://community.qlik.com/t5/QlikView/How-does-calculation-time-depend-on-IF-condition/m-p/1374054#M419623 Anil_Babu_Samineni 2017-09-07T15:34:07Z