topic Re: Transformation in QlikView https://community.qlik.com/t5/QlikView/test1/m-p/1012010#M343281 <HTML><HEAD></HEAD><BODY><P>This is a dynamic version of it that will take any number of days and transform it into rows...</P></BODY></HTML> Tue, 03 Nov 2015 22:49:07 GMT petter 2015-11-03T22:49:07Z test1 https://community.qlik.com/t5/QlikView/test1/m-p/1012003#M343274 <HTML><HEAD></HEAD><BODY><P>ss</P></BODY></HTML> Tue, 03 Nov 2015 05:21:40 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012003#M343274 2015-11-03T05:21:40Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012004#M343275 <HTML><HEAD></HEAD><BODY><P>This is one way of doing it:</P><P></P><P><IMG alt="2015-11-03 #3.PNG" class="jive-image image-1" src="/legacyfs/online/103770_2015-11-03 #3.PNG" style="height: 566px; width: 620px;" /></P><P></P><P><IMG alt="2015-11-03 #4.PNG" class="jive-image image-2" src="/legacyfs/online/103771_2015-11-03 #4.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 03 Nov 2015 06:23:31 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012004#M343275 petter 2015-11-03T06:23:31Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012005#M343276 <HTML><HEAD></HEAD><BODY><P>What about Date column petter </P></BODY></HTML> Tue, 03 Nov 2015 07:09:28 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012005#M343276 2015-11-03T07:09:28Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012006#M343277 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> yes I overlooked/forgot about that - but here is a slightly modified script to cater for that. Had to split the preceding load and make it into a resident load instead to get hold of the dates:</P><P></P><P><IMG alt="2015-11-03 #5.PNG" class="jive-image image-1" src="/legacyfs/online/103775_2015-11-03 #5.PNG" style="height: auto;" /></P><P></P><P><IMG alt="2015-11-03 #6.PNG" class="jive-image image-2" src="/legacyfs/online/103776_2015-11-03 #6.PNG" style="height: 667px; width: 620px;" /></P></BODY></HTML> Tue, 03 Nov 2015 07:34:09 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012006#M343277 petter 2015-11-03T07:34:09Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012007#M343278 <HTML><HEAD></HEAD><BODY><P>For two days data it is good but we are getting monthly data.. then I need to change for daily?</P><P>Is there any solution Petter?</P></BODY></HTML> Tue, 03 Nov 2015 08:26:18 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012007#M343278 2015-11-03T08:26:18Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012008#M343279 <HTML><HEAD></HEAD><BODY><P>You should have mentioned this in the first place - because then I would have suggested a different more dynamic approach. I will not be able to suggest anything until later today ... I&nbsp; actually have a solution made previously I could provide you with later this evening... </P></BODY></HTML> Tue, 03 Nov 2015 10:51:35 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012008#M343279 petter 2015-11-03T10:51:35Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012009#M343280 <HTML><HEAD></HEAD><BODY><P>K &amp; Thank u very much for your valuable time Petter.......</P></BODY></HTML> Tue, 03 Nov 2015 10:57:50 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012009#M343280 2015-11-03T10:57:50Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012010#M343281 <HTML><HEAD></HEAD><BODY><P>This is a dynamic version of it that will take any number of days and transform it into rows...</P></BODY></HTML> Tue, 03 Nov 2015 22:49:07 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012010#M343281 petter 2015-11-03T22:49:07Z Re: Transformation https://community.qlik.com/t5/QlikView/test1/m-p/1012011#M343282 <HTML><HEAD></HEAD><BODY><P>I Have some doubts Petter....</P><P>Please send me your mailid</P></BODY></HTML> Fri, 06 Nov 2015 11:55:42 GMT https://community.qlik.com/t5/QlikView/test1/m-p/1012011#M343282 2015-11-06T11:55:42Z