topic Re: script side expression in QlikView https://community.qlik.com/t5/QlikView/tesst/m-p/1395175#M423619 <HTML><HEAD></HEAD><BODY><P>suggestions please</P></BODY></HTML> Fri, 22 Sep 2017 07:59:18 GMT Anonymous 2017-09-22T07:59:18Z tesst https://community.qlik.com/t5/QlikView/tesst/m-p/1395167#M423611 <HTML><HEAD></HEAD><BODY><P>Hi all,</P></BODY></HTML> Fri, 22 Sep 2017 04:00:56 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395167#M423611 Anonymous 2017-09-22T04:00:56Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395168#M423612 <HTML><HEAD></HEAD><BODY><P>any suggestions</P></BODY></HTML> Fri, 22 Sep 2017 04:17:35 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395168#M423612 Anonymous 2017-09-22T04:17:35Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395169#M423613 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P><A href="https://community.qlik.com/thread/158346">12 month rolling data</A></P></BODY></HTML> Fri, 22 Sep 2017 04:20:33 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395169#M423613 prma7799 2017-09-22T04:20:33Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395170#M423614 <HTML><HEAD></HEAD><BODY><P>Thanks but i need in script side - not on to chart level expression.</P><P>Could you please suggest how to do from script side</P></BODY></HTML> Fri, 22 Sep 2017 04:29:49 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395170#M423614 Anonymous 2017-09-22T04:29:49Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395171#M423615 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table?_ga=2.26787455.377602995.1505970103-1119322831.1481611876" title="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table?_ga=2.26787455.377602995.1505970103-1119322831.1481611876">https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table?_ga=2.26787455.377602995.1505970103-1119322831.1481611876</A></P></BODY></HTML> Fri, 22 Sep 2017 04:32:06 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395171#M423615 prma7799 2017-09-22T04:32:06Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395172#M423616 <HTML><HEAD></HEAD><BODY><P>Hello John,</P><P></P><P>After creating rolling month calendar. You need to go with left join of calendar with fact table.</P><P>Next step is to go for group by with where condition RollingType = R12M.</P><P></P><P>MidFact:</P><P>Load *,KeyDate</P><P>resident <SPAN style="font-size: 13.3333px;">FactTable;</SPAN></P><P></P><P>Left join</P><P>Load </P><P>KeyDate,</P><P>AsofMonth,</P><P>RollingType</P><P>Calendar table;</P><P></P><P>FinalFact:</P><P>Load </P><P>KeyDate,</P><P>sum(Measure) as Measure12M</P><P>Resident MidFact</P><P>where RollingType = R12M</P><P>group by *;</P></BODY></HTML> Fri, 22 Sep 2017 04:35:24 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395172#M423616 balar025 2017-09-22T04:35:24Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395173#M423617 <HTML><HEAD></HEAD><BODY><P>Ravi thanks for sharing this info</P><P></P><P>- unfortunately i didnot received the result <BR />could you please share qvw- apologies </P></BODY></HTML> Fri, 22 Sep 2017 05:07:37 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395173#M423617 Anonymous 2017-09-22T05:07:37Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395174#M423618 <HTML><HEAD></HEAD><BODY><P>any suggestions pls</P></BODY></HTML> Fri, 22 Sep 2017 06:11:51 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395174#M423618 Anonymous 2017-09-22T06:11:51Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395175#M423619 <HTML><HEAD></HEAD><BODY><P>suggestions please</P></BODY></HTML> Fri, 22 Sep 2017 07:59:18 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395175#M423619 Anonymous 2017-09-22T07:59:18Z Re: script side expression https://community.qlik.com/t5/QlikView/tesst/m-p/1395176#M423620 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P>see Attachment.</P><P>I have used AsOf Table Method.</P><P>You see changes in Script Main section.</P><P>Regards,</P><P>Antonio</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177424_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 22 Sep 2017 09:59:32 GMT https://community.qlik.com/t5/QlikView/tesst/m-p/1395176#M423620 antoniotiman 2017-09-22T09:59:32Z