topic Re: advanced scripting in QlikView https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866299#M1216335 <P>Hi MarcoWedel,</P> <P>Thank you so much. Perfect solution .</P> <P>once again Thank You so much.</P> <P>Regards</P> <P>Krish</P> <P>&nbsp;</P> Fri, 03 Dec 2021 04:44:20 GMT Kris1 2021-12-03T04:44:20Z advanced scripting https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866024#M1216328 <P>Hi All,</P> <P>Thanks for your help in advance. <STRONG>Please help how to write script for the following requirement</STRONG>.</P> <TABLE width="128"> <TBODY> <TR> <TD colspan="2" width="128">Original Data</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Programs</TD> <TD>Year</TD> </TR> <TR> <TD>a</TD> <TD>2021</TD> </TR> <TR> <TD>ab</TD> <TD>2021</TD> </TR> <TR> <TD>abc</TD> <TD>2022</TD> </TR> <TR> <TD>abcd</TD> <TD>2022</TD> </TR> <TR> <TD>abcde</TD> <TD>2023</TD> </TR> <TR> <TD>abcdef</TD> <TD>2024</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE width="192"> <TBODY> <TR> <TD colspan="3" width="192">Data format to be prepared Like this</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Program</TD> <TD>Year</TD> <TD>New Year</TD> </TR> <TR> <TD>a</TD> <TD>2021</TD> <TD>2021</TD> </TR> <TR> <TD>ab</TD> <TD>2021</TD> <TD>2021</TD> </TR> <TR> <TD>a</TD> <TD>2021</TD> <TD>2022</TD> </TR> <TR> <TD>ab</TD> <TD>2021</TD> <TD>2022</TD> </TR> <TR> <TD>abc</TD> <TD>2022</TD> <TD>2022</TD> </TR> <TR> <TD>abcd</TD> <TD>2022</TD> <TD>2022</TD> </TR> <TR> <TD>a</TD> <TD>2021</TD> <TD>2023</TD> </TR> <TR> <TD>ab</TD> <TD>2021</TD> <TD>2023</TD> </TR> <TR> <TD>abc</TD> <TD>2022</TD> <TD>2023</TD> </TR> <TR> <TD>abcd</TD> <TD>2022</TD> <TD>2023</TD> </TR> <TR> <TD>abcde</TD> <TD>2023</TD> <TD>2023</TD> </TR> <TR> <TD>a</TD> <TD>2021</TD> <TD>2024</TD> </TR> <TR> <TD>ab</TD> <TD>2021</TD> <TD>2024</TD> </TR> <TR> <TD>abc</TD> <TD>2022</TD> <TD>2024</TD> </TR> <TR> <TD>abcd</TD> <TD>2022</TD> <TD>2024</TD> </TR> <TR> <TD>abcde</TD> <TD>2023</TD> <TD>2024</TD> </TR> <TR> <TD>abcdef</TD> <TD>2024</TD> <TD>2024</TD> </TR> </TBODY> </TABLE> Thu, 02 Dec 2021 13:19:02 GMT https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866024#M1216328 Kris1 2021-12-02T13:19:02Z Re: advanced scripting https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866238#M1216333 <P>&nbsp;</P> <P>Hi,</P> <P>maybe one solution could be:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_1-1638475927408.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67841i982F6AF87D972396/image-size/medium?v=v2&amp;px=400" role="button" title="MarcoWedel_1-1638475927408.png" alt="MarcoWedel_1-1638475927408.png" /></span></P> <P>&nbsp;</P> <LI-CODE lang="markup">table1: LOAD * INLINE [ Programs, Year a, 2021 ab, 2021 abc, 2022 abcd, 2022 abcde, 2023 abcdef, 2024 ]; table2: LOAD *, Year+IterNo()-1 as NewYear While Year+IterNo()-1&lt;=MaxYear; LOAD *, Alt(Peek(MaxYear),Year) as MaxYear Resident table1 Order By Year desc; DROP Table table1;</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>hope this helps</P> <P>Marco</P> Thu, 02 Dec 2021 20:12:20 GMT https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866238#M1216333 MarcoWedel 2021-12-02T20:12:20Z Re: advanced scripting https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866299#M1216335 <P>Hi MarcoWedel,</P> <P>Thank you so much. Perfect solution .</P> <P>once again Thank You so much.</P> <P>Regards</P> <P>Krish</P> <P>&nbsp;</P> Fri, 03 Dec 2021 04:44:20 GMT https://community.qlik.com/t5/QlikView/advanced-scripting/m-p/1866299#M1216335 Kris1 2021-12-03T04:44:20Z