topic Re: Script for this output in QlikView https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332419#M460379 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean? May be you need <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Thu, 25 May 2017 09:21:03 GMT sunny_talwar 2017-05-25T09:21:03Z Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332414#M460374 <HTML><HEAD></HEAD><BODY><P>I am attaching problem pic and expected result pic.</P><P></P><P>please let me know how it is possible to get result pic.<IMG alt="result.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164651_result.JPG" style="height: 132px; width: 620px;" /></P><P></P><P></P><P>problem pic:-</P><P><IMG alt="problem.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/164652_problem.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 24 May 2017 16:25:25 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332414#M460374 shiveshsingh 2017-05-24T16:25:25Z Re: Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332415#M460375 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; Month(MonthStart(Date, Jump*(IterNo()-1))) as Month</STRONG></P><P><STRONG>While IterNo() &lt;= Freq;</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; 12/Freq as Jump;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Account No, Freq, Date</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10001, 12, 03-04-2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10002, 1, 05-06-2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10003, 4, 03-02-2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10004, 4, 05-07-2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10005, 2, 04-04-2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 10006, 2, 07-07-2015</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164643_Capture.PNG" style="height: 144px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 24 May 2017 16:35:55 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332415#M460375 sunny_talwar 2017-05-24T16:35:55Z Re: Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332416#M460376 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>plz share expression, license fr qliview is over</P></BODY></HTML> Thu, 25 May 2017 02:11:24 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332416#M460376 shiveshsingh 2017-05-25T02:11:24Z Re: Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332417#M460377 <HTML><HEAD></HEAD><BODY><P>Expression</P><P><STRONG>=Count([Account No])</STRONG></P></BODY></HTML> Thu, 25 May 2017 02:13:12 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332417#M460377 sunny_talwar 2017-05-25T02:13:12Z Re: Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332418#M460378 <HTML><HEAD></HEAD><BODY><P>how can we expand month to column, like jan, feb, march should be a newcolumn..</P><P>when i m loading, those are coming in one column i.e. month</P></BODY></HTML> Thu, 25 May 2017 02:40:25 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332418#M460378 shiveshsingh 2017-05-25T02:40:25Z Re: Script for this output https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332419#M460379 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean? May be you need <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Thu, 25 May 2017 09:21:03 GMT https://community.qlik.com/t5/QlikView/Script-for-this-output/m-p/1332419#M460379 sunny_talwar 2017-05-25T09:21:03Z