topic functions in QlikView https://community.qlik.com/t5/QlikView/functions/m-p/834290#M991942 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>how to use 'if' condition in script level? give me one example.</P></BODY></HTML> Wed, 08 Jul 2015 17:06:49 GMT maniram23 2015-07-08T17:06:49Z functions https://community.qlik.com/t5/QlikView/functions/m-p/834290#M991942 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>how to use 'if' condition in script level? give me one example.</P></BODY></HTML> Wed, 08 Jul 2015 17:06:49 GMT https://community.qlik.com/t5/QlikView/functions/m-p/834290#M991942 maniram23 2015-07-08T17:06:49Z Re: functions https://community.qlik.com/t5/QlikView/functions/m-p/834291#M991943 <HTML><HEAD></HEAD><BODY><P>There must be numerous examples available on the community. Below an example for you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Let vStartDateNum = Num(MakeDate(2013,1,1));</P><P></P><P>Let vEndDateNum = Num(Today());</P><P></P><P></P><P>Calendar:</P><P>LOAD</P><P>Date,</P><P>Year(Date) as Year,</P><P><STRONG>If(MonthName(Date)=MonthName(Today()),1,0) as CURR_MNTH_FLG,</STRONG></P><P><STRONG>If(MonthName(Date)=MonthName(MonthStart(AddMonths(Today(),-1))),1,0) as PREV_MNT_FLG;</STRONG></P><P>Load</P><P>Date($(vStartDateNum)+RecNo()-1) as Date</P><P>AutoGenerate $(vEndDateNum)-$(vStartDateNum)+1;</P><P></P><P>Regards,</P><P>KKR</P></BODY></HTML> Wed, 08 Jul 2015 17:43:16 GMT https://community.qlik.com/t5/QlikView/functions/m-p/834291#M991943 2015-07-08T17:43:16Z