topic Re: GetFieldSelections-Function - calculate the previous month in QlikView

GetFieldSelections-Function - calculate the previous month

neapicture — Mon, 26 Jan 2026 18:19:17 GMT

Hey Guys,

I have a problem with the GetFieldSelections-Function. I would like the Month before the Selection (previous month)

That is my expression:

=Sum({<Monat={"$(=GetFieldSelections(Monat)-1)"}>}Plan)

The calculation of the currently selected month works

Could you help me?

Thank you very much!

tresB — Mon, 09 Apr 2018 09:17:43 GMT

Are you selecting a single month value? How did you create month field in the script, using month()?

neapicture — Mon, 09 Apr 2018 09:25:37 GMT

Yes, a single month is always chosen.

Only there does the calculation need to work

... and i use Month()

Month(Datumsfeld) AS Monat,

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

---

tresB — Mon, 09 Apr 2018 09:32:32 GMT

Try formatting the dual to string for set comparison like:

=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'M')))"}>}Plan)

tresB — Mon, 09 Apr 2018 09:32:44 GMT

Try formatting the dual to string for set comparison like:

=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'M')))"}>}Plan)

neapicture — Mon, 09 Apr 2018 10:40:47 GMT

...the part of the formula "-1" does not work for me. I think there is the problem. But I have no solution

=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'MMM')))"}>}Plan)

tresB — Mon, 09 Apr 2018 10:46:19 GMT

Could you post a sample qvw?