topic if condition in qlikview in QlikView https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329617#M410907 <HTML><HEAD></HEAD><BODY><P>if(x&lt;=y) then output is a</P><P>if(x=y)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</P><P>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c</P><P></P><P>where a,b c will be used as flag</P></BODY></HTML> Thu, 27 Apr 2017 09:34:12 GMT Anonymous 2017-04-27T09:34:12Z if condition in qlikview https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329617#M410907 <HTML><HEAD></HEAD><BODY><P>if(x&lt;=y) then output is a</P><P>if(x=y)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</P><P>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c</P><P></P><P>where a,b c will be used as flag</P></BODY></HTML> Thu, 27 Apr 2017 09:34:12 GMT https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329617#M410907 Anonymous 2017-04-27T09:34:12Z Re: if condition in qlikview https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329618#M410908 <HTML><HEAD></HEAD><BODY><P>Please try below:</P><P></P><P>If(x&lt;=y, a, <SPAN style="font-size: 13.3333px;">If(x=y, b, c)</SPAN>) or <SPAN style="font-size: 13.3333px;">If(x&lt;=y, 'a', </SPAN><SPAN style="font-size: 13.3333px;">If(x=y, 'b', 'c')</SPAN><SPAN style="font-size: 13.3333px;">)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards!</SPAN></P><P><SPAN style="font-size: 13.3333px;">Rahul</SPAN></P></BODY></HTML> Thu, 27 Apr 2017 09:37:51 GMT https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329618#M410908 rahulpawarb 2017-04-27T09:37:51Z Re: if condition in qlikview https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329619#M410909 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>try this,</P><P></P><P>if(x&lt;=y,'a',if(x=y,'b','c')) as flag</P><P></P><P>Regards,</P></BODY></HTML> Thu, 27 Apr 2017 09:45:44 GMT https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329619#M410909 PrashantSangle 2017-04-27T09:45:44Z Re: if condition in qlikview https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329620#M410910 <HTML><HEAD></HEAD><BODY><P>Your condition makes no sense to me, because its not clear what happens in case of x=y.</P><P>In your example it could be either a or b.</P><P>shouldn´t it be something like this:</P><P>if(x&lt;y,'a',if(x=y,'b',if(x&gt;y,'c'))) as Flag</P><P></P><P>hope this helps</P></BODY></HTML> Thu, 27 Apr 2017 09:49:13 GMT https://community.qlik.com/t5/QlikView/if-condition-in-qlikview/m-p/1329620#M410910 Frank_Hartmann 2017-04-27T09:49:13Z