topic Calculate only IF in QlikView https://community.qlik.com/t5/QlikView/Calculate-only-IF/m-p/1426314#M429530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i would like to have the expression VINTO, calculated only if Sales &amp;(vPriorYear) is equal to 0.</P><P>How this can be achieved?</P><P>Thank you</P><P></P><P><IMG alt="if.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182342_if.PNG" style="height: 109px; width: 620px;" /></P></BODY></HTML> Tue, 07 Nov 2017 08:55:15 GMT qlikviewaf 2017-11-07T08:55:15Z Calculate only IF https://community.qlik.com/t5/QlikView/Calculate-only-IF/m-p/1426314#M429530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i would like to have the expression VINTO, calculated only if Sales &amp;(vPriorYear) is equal to 0.</P><P>How this can be achieved?</P><P>Thank you</P><P></P><P><IMG alt="if.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182342_if.PNG" style="height: 109px; width: 620px;" /></P></BODY></HTML> Tue, 07 Nov 2017 08:55:15 GMT https://community.qlik.com/t5/QlikView/Calculate-only-IF/m-p/1426314#M429530 qlikviewaf 2017-11-07T08:55:15Z Re: Calculate only IF https://community.qlik.com/t5/QlikView/Calculate-only-IF/m-p/1426315#M429531 <HTML><HEAD></HEAD><BODY><P><IMG alt="table.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182344_table.PNG" style="height: auto;" /></P><P>in additions: i would like to have VINTO calculated only if sales 2016 is equal to 0.</P></BODY></HTML> Tue, 07 Nov 2017 09:04:43 GMT https://community.qlik.com/t5/QlikView/Calculate-only-IF/m-p/1426315#M429531 qlikviewaf 2017-11-07T09:04:43Z