topic Rolling 12 - Trouble with selecting specific date in QlikView https://community.qlik.com/t5/QlikView/Rolling-12-Trouble-with-selecting-specific-date/m-p/191781#M53734 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P>I am having trouble with a Rolling 12 graph. When no year is selected all the figures are correct. But since my formula is using ABOVE, when selecting a specific year there are no rows above and the sum starts from the first selected month. I need the year-slice to show the same values as from when no specific filter on year is set.</P><P>This is how I do it:<BR />RangeSum(Above(Sum({$&lt;YearMonth = {"&lt;=$(=max(YearMonth))"}&gt;}[Data]),0,12))</P><P>I know I probably must do something in the script when I load the data but I cannot figure out what.</P><P>Please, any suggestions?<BR />/Peter</P></BODY></HTML> Thu, 17 Jun 2010 09:02:03 GMT 2010-06-17T09:02:03Z Rolling 12 - Trouble with selecting specific date https://community.qlik.com/t5/QlikView/Rolling-12-Trouble-with-selecting-specific-date/m-p/191781#M53734 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P>I am having trouble with a Rolling 12 graph. When no year is selected all the figures are correct. But since my formula is using ABOVE, when selecting a specific year there are no rows above and the sum starts from the first selected month. I need the year-slice to show the same values as from when no specific filter on year is set.</P><P>This is how I do it:<BR />RangeSum(Above(Sum({$&lt;YearMonth = {"&lt;=$(=max(YearMonth))"}&gt;}[Data]),0,12))</P><P>I know I probably must do something in the script when I load the data but I cannot figure out what.</P><P>Please, any suggestions?<BR />/Peter</P></BODY></HTML> Thu, 17 Jun 2010 09:02:03 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Trouble-with-selecting-specific-date/m-p/191781#M53734 2010-06-17T09:02:03Z