https://community.qlik.com/t5/QlikView/Get-all-YearMonths-before-current-YearMonth/m-p/1957891#M1219972 <P>I'm attempting to use</P> <P>=[date.autoCalendar.YearMonth]</P> <P>as an expression to group sales by YearMonth.</P> <P>How would I get all entries before the current month?</P> <P>Thank you</P> Tue, 19 Jul 2022 16:01:37 GMT hucand 2022-07-19T16:01:37Z https://community.qlik.com/t5/QlikView/Get-all-YearMonths-before-current-YearMonth/m-p/1957891#M1219972 <P>I'm attempting to use</P> <P>=[date.autoCalendar.YearMonth]</P> <P>as an expression to group sales by YearMonth.</P> <P>How would I get all entries before the current month?</P> <P>Thank you</P> Tue, 19 Jul 2022 16:01:37 GMT https://community.qlik.com/t5/QlikView/Get-all-YearMonths-before-current-YearMonth/m-p/1957891#M1219972 hucand 2022-07-19T16:01:37Z https://community.qlik.com/t5/QlikView/Get-all-YearMonths-before-current-YearMonth/m-p/1958044#M1219978 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/190358">@hucand</a>&nbsp; Could you please try something like a below expression in your chart.</P> <P>Sum({&lt;<SPAN>[date.autoCalendar.YearMonth]</SPAN>={"&lt;$(=Max(<SPAN>[date.autoCalendar.YearMonth]</SPAN>))"}&gt;}SalesAmount)</P> <P>If this resolves your issue, please like and accept it as a solution.</P> Wed, 20 Jul 2022 03:57:56 GMT https://community.qlik.com/t5/QlikView/Get-all-YearMonths-before-current-YearMonth/m-p/1958044#M1219978 sidhiq91 2022-07-20T03:57:56Z