topic How to find current month sales or count vs last year current month sales or count. in App Development

How to find current month sales or count vs last year current month sales or count.

gss123 — Thu, 31 Aug 2023 07:41:37 GMT

Please help me out i m new to qliksense.
I want to know
current month sales = __nos.
previous month sales = __nos.

i want to know the expression for this and i want to add these text in text box chart.

Re: How to find current month sales or count vs last year current month sales or count.

PrashantSangle — Thu, 31 Aug 2023 08:42:02 GMT

Hello ,

Provide some more information about data.

if you have date field then use below expression

current month sales = Sum({<month={"$(=Month(Floor(Today())))"}>}Sales).
previous month sales = Sum({<month={"$(=Month(AddMonth(Floor(Today())),-1))"}>}Sales).

Regards,

Prashant Sangle

Re: How to find current month sales or count vs last year current month sales or count.

Mark_Little — Thu, 31 Aug 2023 09:42:40 GMT

I personally like to use flags in my Master Calendar to make out key periods, then i can just used the flags to calculate any set analysis using the flags