topic Re: if statement problems in QlikView https://community.qlik.com/t5/QlikView/if-statement-problems/m-p/245255#M93509 <HTML><HEAD></HEAD><BODY><P><EM>Try this...</EM></P><P></P><P><STRONG><EM>IF( Left([Referral_Date], 2) = '01', Referral_Date, <SPAN style="color: #ff0000;">'')</SPAN> AS Date2</EM></STRONG></P><P></P><P><EM>I had highlighted else bit in red color.. so that you can replace whatever you wanted.</EM><STRONG><EM><BR /></EM></STRONG></P><P></P><P></P><P><EM>Cheers - DV</EM></P></BODY></HTML> Thu, 30 Jun 2011 10:52:44 GMT IAMDV 2011-06-30T10:52:44Z if statement problems https://community.qlik.com/t5/QlikView/if-statement-problems/m-p/245254#M93508 <HTML><HEAD></HEAD><BODY><P>if(left([Referral_Date], 2) = '01'), Referral_Date as Date2,</P><P></P><P>Can someone tell me what is wrong with this if statement? I keep getting this error... "Error in expression:If takes 2-3 parameters" Thanks</P></BODY></HTML> Thu, 30 Jun 2011 10:45:07 GMT https://community.qlik.com/t5/QlikView/if-statement-problems/m-p/245254#M93508 2011-06-30T10:45:07Z Re: if statement problems https://community.qlik.com/t5/QlikView/if-statement-problems/m-p/245255#M93509 <HTML><HEAD></HEAD><BODY><P><EM>Try this...</EM></P><P></P><P><STRONG><EM>IF( Left([Referral_Date], 2) = '01', Referral_Date, <SPAN style="color: #ff0000;">'')</SPAN> AS Date2</EM></STRONG></P><P></P><P><EM>I had highlighted else bit in red color.. so that you can replace whatever you wanted.</EM><STRONG><EM><BR /></EM></STRONG></P><P></P><P></P><P><EM>Cheers - DV</EM></P></BODY></HTML> Thu, 30 Jun 2011 10:52:44 GMT https://community.qlik.com/t5/QlikView/if-statement-problems/m-p/245255#M93509 IAMDV 2011-06-30T10:52:44Z