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

[arulsettu]

All you need is a date field and you can create month using the date field like below

Month(Date) as Month

then use the Month in set analysis for current month like below

sum({<Month={'$(=Max(Month))'}>}sales)

[coerdn]

Where do i have to calculate that?

"Month(Date) as Month"

And how do i get the prev. month? Month -1?

[arulsettu]

In your load script crate the month field

and previous month in a chart expression like this

Sum({<Month={'$(=max(month)-1)'}>}sales)

Share some sample data to replicate this

[coerdn]

Now i tried your reply, but did not work. First step creation of Month and then visualize with formula. Whats wrong?

[arulsettu]

Can you share sample app with expected output

[coerdn]

Here is the app would be great if you could help me

[arulsettu]

Can you also share the excel used in the qvf

[arulsettu]

Check this