topic Re: Display last month Value in QlikView

Display last month Value

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I need to display the value of the last month and only the last month. I used a text field and the following expression:

= 'Last month: ' &
num(sum({<MonthYear ={"$(='>=' & Max(MonthYear))"}>} Sales) )

When there is not period selection, there is the right display but when I selected a period (month, Year, ..) the value changes. How to modify the expression in order to have the same value indepent from the sélections we can made?

Thank you,

William

Re: Display last month Value

swuehl — Fri, 04 Mar 2016 19:00:46 GMT

You can use the set identifier 1 to ignore all user selections:

= 'Last month: ' &
num(sum({1<MonthYear ={"$(='>=' & Max({1} MonthYear))"}>} Sales) )

Re: Display last month Value

Mon, 07 Mar 2016 09:22:52 GMT

Thank you swuehl! Your expression works great!

Finally I have found this expression :

sum({1<Date={">=$(=MonthStart(Today(), -2))<=$(=Today())"}>} Sales) and it also works!

Thank you,

Regards,

William