topic Re: I need help creating a button to select last month only in QlikView

I need help creating a button to select last month only

Wed, 25 Nov 2020 16:16:04 GMT

I created a button that would select the last week of information using select in field with a field of Week and a search string of

=(Week(today(1))-1)

I also created a button to select the current year using select in field with a fiend of Year and a search string of

=(Year(today(1)))

I also tested it to select last year using a search string of =(Year(today(1))-1)

However using the same format to select last month doesn't work.

Using Month as the field and a search string of =(Month(today(1))-1) it selects nothing.

If I use =(Month(today(1))) I get the current month (as I do if I replace the 1 with a 0 or -1)

How do I make this button select last month?

Thanks all.

krishnacbe — Tue, 18 Oct 2016 16:05:04 GMT

Try below expression

=Month(Today()-1)

Aurelien_Martinez — Tue, 18 Oct 2016 16:06:49 GMT

Hi,

=Month(AddMonths(Today(), -1))

Aurélien

Anil_Babu_Samineni — Tue, 18 Oct 2016 16:12:25 GMT

Are you sure, above all working? If yes, month should work. Can you please share the application where do you applying this. We can have a look

Wed, 19 Oct 2016 07:36:53 GMT

Thank you Aurelian.

This is the solution I needed. Works perfectly.

Thank you.

dhasharadh — Mon, 07 Sep 2020 10:50:59 GMT

I have the similar requirement, but my Month filter is in diff format like YYYY-MM and I want to select last month every time.

my month filter name is GasMonth. =Month(AddMonths(Today(), -1)) this is not working in my case, please help me.