topic If Condition in QlikView https://community.qlik.com/t5/QlikView/If-Condition/m-p/200813#M59196 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to show 'month' values based on 'Mob' values as shown below (assume current month as 201005):</P><P>If Mob=3 then month=201002(i.e. Current month-3) or 200902 (i.e. Current month-3-12),</P><P>similarily if Mob=4 then month=201001 or 200901.</P><P>Is there a way to do so using 'If' condition?</P><P>Kindly help ASAP.</P><P></P></BODY></HTML> Thu, 24 Jun 2010 11:42:20 GMT 2010-06-24T11:42:20Z If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/200813#M59196 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to show 'month' values based on 'Mob' values as shown below (assume current month as 201005):</P><P>If Mob=3 then month=201002(i.e. Current month-3) or 200902 (i.e. Current month-3-12),</P><P>similarily if Mob=4 then month=201001 or 200901.</P><P>Is there a way to do so using 'If' condition?</P><P>Kindly help ASAP.</P><P></P></BODY></HTML> Thu, 24 Jun 2010 11:42:20 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/200813#M59196 2010-06-24T11:42:20Z If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/200814#M59197 <HTML><HEAD></HEAD><BODY><P>Please reply anybody.</P></BODY></HTML> Fri, 25 Jun 2010 10:16:00 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/200814#M59197 2010-06-25T10:16:00Z AW:Re: If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/200815#M59198 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>is your filed month a datefaield? You have lots of datefunctions, look at the helpfile. also set analysis will help.</P><P>Or you can use the function Left(month,4) in dimensions and/or expressions.</P></BODY></HTML> Fri, 25 Jun 2010 10:23:00 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/200815#M59198 brenner_martina 2010-06-25T10:23:00Z