topic Re: previous year counts when using cannonical dates in QlikView https://community.qlik.com/t5/QlikView/previous-year-counts-when-using-cannonical-dates/m-p/101547#M751070 <HTML><HEAD></HEAD><BODY><P>Hi Lahiru, you can add the year filter with last year to the set analysis of the DateType, ie.:</P><P>Sum({&lt;DateType={Invoice}, Year={$(=Max(Year)-1)}&gt;} Sales)</P></BODY></HTML> Fri, 02 Nov 2018 08:04:54 GMT rubenmarin 2018-11-02T08:04:54Z previous year counts when using cannonical dates https://community.qlik.com/t5/QlikView/previous-year-counts-when-using-cannonical-dates/m-p/101546#M751069 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>could some one please tell how to get the sum of for the previous year sales, quantity etc if we have past records for last years as per the given popular example of using <SPAN style="font-size: 10pt;">canonical date.</SPAN></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217365_Capture.PNG" style="height: 283px; width: 620px;" /></P><P></P><P>Thank you</P><P>Madushan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/previous-year-counts-when-using-cannonical-dates/m-p/101546#M751069 madushanfernand 2020-11-25T16:16:04Z Re: previous year counts when using cannonical dates https://community.qlik.com/t5/QlikView/previous-year-counts-when-using-cannonical-dates/m-p/101547#M751070 <HTML><HEAD></HEAD><BODY><P>Hi Lahiru, you can add the year filter with last year to the set analysis of the DateType, ie.:</P><P>Sum({&lt;DateType={Invoice}, Year={$(=Max(Year)-1)}&gt;} Sales)</P></BODY></HTML> Fri, 02 Nov 2018 08:04:54 GMT https://community.qlik.com/t5/QlikView/previous-year-counts-when-using-cannonical-dates/m-p/101547#M751070 rubenmarin 2018-11-02T08:04:54Z