Sales of current and prev. Month

[coerdn]

Hi together,

i want to display to KPI's.

First is sales of current month and second is Sales of previous month. Everything should work dynamic linked to the selected month in the filter pane. 

I already tried this: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Measures/create-calendar...

Do i have to do something in advance?

Many thanks

[coerdn]

many thanks. but what did you calculate in monthnum? can you send me the xls?

[arulsettu · Accepted solution]

It just converting Month to numbers within qlik. Please mark the correct answer to the reply

[Gabriel]

Hi,

Can I suggest you create Master Calendar first if you don't already have one.

However, quick solution I will suggest from your data is to create 2 variables

LET vMaxDate               = '=DATE(MAX([Sales Date]))';
LET vPrevMonthDate = '$(vMaxDate)-1';

Then your KPIs

Current Month = SUM({<[Sales Date]={'$(vMaxDate)'}>} Sales)

Prev Month        = SUM({<[Sales Date]={'=DATE($(vPrevMonthDate))'}>} Sales)

Hope this helps

[coerdn]

How can i create a master calender

[Gabriel]

Hi,

You've marked your initial question as answered, so to create calendar you need to search the community here. 

[coerdn]

But in the Expression of the Measure for the prev. Month you do not use this Monthnum. So is it necessary?

[arulsettu]

No