topic Nested IF - flag Script in QlikView https://community.qlik.com/t5/QlikView/Nested-IF-flag-Script/m-p/407456#M696007 <HTML><HEAD></HEAD><BODY><P>hi i am trying to achieve the following logic.</P><P>i would like to create a flag based on the following statement;</P><P></P><P></P><P>i seem to have a brackets issue however <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>=if <STRONG style=": ; color: #ff0000; font-size: 8pt;">(</STRONG><SPAN style="color: #800000; font-size: 8pt;">Artikeltyp</SPAN><SPAN style="font-size: 8pt;"> = 'Z' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;"> </SPAN><STRONG style=": ; color: #ff0000; font-size: 8pt;">(</STRONG><SPAN style="color: #800000; font-size: 8pt;">MovementDate</SPAN><SPAN style="font-size: 8pt;"> &gt; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">dayend</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Now</SPAN><SPAN style="font-size: 8pt;">() -365)1, 0) ) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> moving</SPAN></P></BODY></HTML> Sun, 28 Apr 2013 09:35:49 GMT 2013-04-28T09:35:49Z Nested IF - flag Script https://community.qlik.com/t5/QlikView/Nested-IF-flag-Script/m-p/407456#M696007 <HTML><HEAD></HEAD><BODY><P>hi i am trying to achieve the following logic.</P><P>i would like to create a flag based on the following statement;</P><P></P><P></P><P>i seem to have a brackets issue however <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>=if <STRONG style=": ; color: #ff0000; font-size: 8pt;">(</STRONG><SPAN style="color: #800000; font-size: 8pt;">Artikeltyp</SPAN><SPAN style="font-size: 8pt;"> = 'Z' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;"> </SPAN><STRONG style=": ; color: #ff0000; font-size: 8pt;">(</STRONG><SPAN style="color: #800000; font-size: 8pt;">MovementDate</SPAN><SPAN style="font-size: 8pt;"> &gt; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">dayend</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Now</SPAN><SPAN style="font-size: 8pt;">() -365)1, 0) ) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> moving</SPAN></P></BODY></HTML> Sun, 28 Apr 2013 09:35:49 GMT https://community.qlik.com/t5/QlikView/Nested-IF-flag-Script/m-p/407456#M696007 2013-04-28T09:35:49Z Re: Nested IF - flag Script https://community.qlik.com/t5/QlikView/Nested-IF-flag-Script/m-p/407457#M696008 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>if (Artikeltyp = 'Z' and MovementDate &gt; addyears(today(1),-1) , 1, 0) as moving</P></BODY></HTML> Sun, 28 Apr 2013 19:39:39 GMT https://community.qlik.com/t5/QlikView/Nested-IF-flag-Script/m-p/407457#M696008 Gysbert_Wassenaar 2013-04-28T19:39:39Z