https://community.qlik.com/t5/App-Development/cross-table-dynamic-date/m-p/2121285#M91297 <P>Hi , i cant figure that out so maybe you can help me with that .&nbsp;<BR />I have a data set i'm trying to convert into table with crosstable function</P> <P>I have a product list , every column represent next months. and values inside.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jordan231_0-1695370268621.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116830i0516AB79397AC454/image-size/medium?v=v2&amp;px=400" role="button" title="jordan231_0-1695370268621.png" alt="jordan231_0-1695370268621.png" /></span></P> <P>&nbsp;</P> <P>I managed to have good strucutre but i would like to make also a dates for every record on the fly.&nbsp;&nbsp;<BR />I can do that with resident load but maybe there is a better way ? Any ideas ? thanks !&nbsp;</P> Fri, 22 Sep 2023 08:13:33 GMT jordan231 2023-09-22T08:13:33Z https://community.qlik.com/t5/App-Development/cross-table-dynamic-date/m-p/2121285#M91297 <P>Hi , i cant figure that out so maybe you can help me with that .&nbsp;<BR />I have a data set i'm trying to convert into table with crosstable function</P> <P>I have a product list , every column represent next months. and values inside.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jordan231_0-1695370268621.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116830i0516AB79397AC454/image-size/medium?v=v2&amp;px=400" role="button" title="jordan231_0-1695370268621.png" alt="jordan231_0-1695370268621.png" /></span></P> <P>&nbsp;</P> <P>I managed to have good strucutre but i would like to make also a dates for every record on the fly.&nbsp;&nbsp;<BR />I can do that with resident load but maybe there is a better way ? Any ideas ? thanks !&nbsp;</P> Fri, 22 Sep 2023 08:13:33 GMT https://community.qlik.com/t5/App-Development/cross-table-dynamic-date/m-p/2121285#M91297 jordan231 2023-09-22T08:13:33Z https://community.qlik.com/t5/App-Development/cross-table-dynamic-date/m-p/2121311#M91299 <P>tab:<BR />CrossTable(col1,col2)<BR />load * Inline [<BR />c1,1,2<BR />A,5,6<BR />B,8,9</P> <P>];<BR /><BR />NoConcatenate<BR />LOAD *,AddMonths( Today(),num#(col1)) as Mth Resident tab;<BR />DROP Table tab;</P> Fri, 22 Sep 2023 09:22:46 GMT https://community.qlik.com/t5/App-Development/cross-table-dynamic-date/m-p/2121311#M91299 anat 2023-09-22T09:22:46Z