topic Re: Macros unparised load faild in QlikView https://community.qlik.com/t5/QlikView/Macros-unparised-load-faild/m-p/1129248#M371328 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14671083040358201 jive_text_macro" jivemacro_uid="_14671083040358201" modifiedtitle="true"> <P>SUB DateRange</P> <P>&nbsp; IF ActiveDocument.Variables("DateRange").GetContent.String = "1" THEN&nbsp; </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "&lt;=" &amp; ActiveDocument.Variables("vDefaultDateRange").GetContent.String</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=1 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "YTD" </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ELSE </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=2 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "MTD" </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=3 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "WTD"</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "PTD"</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Variables("DateRange").SetContent "0", True</P> <P>&nbsp; ELSE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Variables("DateRange").SetContent "1", True</P> <P>&nbsp; END IF</P> <P>END SUB</P> </PRE></BODY></HTML> Tue, 28 Jun 2016 09:46:20 GMT tamilarasu 2016-06-28T09:46:20Z Macros unparised load faild https://community.qlik.com/t5/QlikView/Macros-unparised-load-faild/m-p/1129247#M371327 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>I got the eroor like Macros Unparised load faild, Can any one help me on that..</P><P>My Vbscript as below:</P><P></P><P>SUB DateRange</P><P>&nbsp; IF ActiveDocument.Variables("DateRange").GetContent.String = "1" THEN</P><P>&nbsp; ActiveDocument.Fields("DateRange").Select "&lt;=" &amp; ActiveDocument.Variables("vDefaultDateRange").GetContent.String </P><P>&nbsp; IF vDefaultDateRange=1 THEN</P><P>&nbsp; ActiveDocument.Fields("DateRange").Select "YTD"</P><P>&nbsp; ELSE IF vDefaultDateRange=2 THEN</P><P>&nbsp; ActiveDocument.Fields("DateRange").Select "MTD"</P><P>&nbsp; ELSE IF vDefaultDateRange=3 THEN</P><P>&nbsp; ActiveDocument.Fields("DateRange").Select "WTD"</P><P>&nbsp; Else</P><P>&nbsp; ActiveDocument.Fields("DateRange").Select "PTD"</P><P>&nbsp; END IF</P><P>&nbsp; END IF</P><P>&nbsp; END IF</P><P>&nbsp; END IF</P><P>&nbsp; ActiveDocument.Variables("DateRange").SetContent "0", True</P><P>&nbsp; ELSE</P><P>&nbsp; ActiveDocument.Variables("DateRange").SetContent "1", True</P><P>&nbsp; END IF</P><P>END SUB</P><P></P><P></P><P>Thanks</P><P>Siva</P></BODY></HTML> Tue, 28 Jun 2016 09:13:20 GMT https://community.qlik.com/t5/QlikView/Macros-unparised-load-faild/m-p/1129247#M371327 2016-06-28T09:13:20Z Re: Macros unparised load faild https://community.qlik.com/t5/QlikView/Macros-unparised-load-faild/m-p/1129248#M371328 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14671083040358201 jive_text_macro" jivemacro_uid="_14671083040358201" modifiedtitle="true"> <P>SUB DateRange</P> <P>&nbsp; IF ActiveDocument.Variables("DateRange").GetContent.String = "1" THEN&nbsp; </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "&lt;=" &amp; ActiveDocument.Variables("vDefaultDateRange").GetContent.String</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=1 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "YTD" </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ELSE </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=2 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "MTD" </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF vDefaultDateRange=3 THEN </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "WTD"</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("DateRange").Select "PTD"</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Variables("DateRange").SetContent "0", True</P> <P>&nbsp; ELSE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Variables("DateRange").SetContent "1", True</P> <P>&nbsp; END IF</P> <P>END SUB</P> </PRE></BODY></HTML> Tue, 28 Jun 2016 09:46:20 GMT https://community.qlik.com/t5/QlikView/Macros-unparised-load-faild/m-p/1129248#M371328 tamilarasu 2016-06-28T09:46:20Z