topic Create a Straight Table with only latest 24 months data in QlikView https://community.qlik.com/t5/QlikView/Create-a-Straight-Table-with-only-latest-24-months-data/m-p/688269#M1078166 <HTML><HEAD></HEAD><BODY><P>I have some sales data with Month-Year in the Row, whereas I would like the Month-Year to appear as columns instead and also I want only the first 24 months always. So everytime I reload the data, I want the table to be automatically updated with only latest 24 months of data. PFA the data for the same. </P><P></P><P>I tried to add expressions for each month which will get calculated dynamically using Addmonths and match function and I was unable to do so. Also I tried using set analysis but was unable to get the correct expressions.</P><P></P><P>FYI the initial data load is a Binary Load, if it is relevant.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Create a Straight Table with only latest 24 months data https://community.qlik.com/t5/QlikView/Create-a-Straight-Table-with-only-latest-24-months-data/m-p/688269#M1078166 <HTML><HEAD></HEAD><BODY><P>I have some sales data with Month-Year in the Row, whereas I would like the Month-Year to appear as columns instead and also I want only the first 24 months always. So everytime I reload the data, I want the table to be automatically updated with only latest 24 months of data. PFA the data for the same. </P><P></P><P>I tried to add expressions for each month which will get calculated dynamically using Addmonths and match function and I was unable to do so. Also I tried using set analysis but was unable to get the correct expressions.</P><P></P><P>FYI the initial data load is a Binary Load, if it is relevant.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Create-a-Straight-Table-with-only-latest-24-months-data/m-p/688269#M1078166 2020-11-20T18:02:30Z Re: Create a Straight Table with only latest 24 months data https://community.qlik.com/t5/QlikView/Create-a-Straight-Table-with-only-latest-24-months-data/m-p/688270#M1078167 <HTML><HEAD></HEAD><BODY><P>Have u tried Dimension limits??</P></BODY></HTML> Wed, 16 Jul 2014 13:33:19 GMT https://community.qlik.com/t5/QlikView/Create-a-Straight-Table-with-only-latest-24-months-data/m-p/688270#M1078167 2014-07-16T13:33:19Z