Previous Month and previous year product sales

[sunil-kumar5]

Hi All,

I was able to create KPI for current month and current year product sales based on ID. Now I am looking for last month sales and last year sale. This is will not required some the expression will be start with count(distinct..

Product ID	Installation Date
6817	01-02-2017
4939	01-02-2018
5423	01-02-2019
2303	01-02-2020
3226	01-02-2017
3064	01-02-2018
3547	08-07-2020
7862	08-07-2020
6030	01-02-2017
7810	01-02-2018
5800	01-02-2019
4390	08-07-2020
7808	01-02-2017
5835	01-02-2018
6293	01-02-2019
7019	08-15-2020
7987	08-02-2020

Please advise as its urgently needed.

Thanks

Sunil Kumar

[tresesco · Accepted solution]

Check it here : https://community.qlik.com/t5/New-to-Qlik-Sense/Current-Month-and-Previous-Month-Product-Count-on-KP...

Count(Distinct {<Year={'$(=Year(Today()))'}, Month={'$(=Month(Today()))'}>} [Product ID] )

[sunil-kumar5]

Superb!! Thanks Tresesco for the solutions. I have MTD ,YTD , Previous Month and Last year on the basis of expression your provided.

Will you please help me to calculate the quarter sales as well, not able to get it correct. Like current quarter vs previous quarter?