Macro Problem: Selecting Previous Month

Wed, 20 Feb 2013 16:56:26 GMT

Hi,

I have a problem in where i'm showing a Balanced Score Card on my dashboard. My employer asked me to select the previous month by default so that the tables show some values when the user views the dashboard. The only way conceivable of doing this, as I have found so far is to create a Macro function that runs on a trigger when OpenDocument occurs. I was able to get the current month and year by doing this:

sub DefaultLAFP2

v_monthyear = UCASE(Monthname(Month(now()),TRUE)) & " " & right(Year(now()),2)

ActiveDocument.Fields("MonthYear").Select v_monthyear

end sub

The MonthYear field has values such as: JAN 13, FEB 13, MAR 13, etc...

When I tried putting the -1 after the Month I was unable to get the desired result. I believe this is because QlikView doesn't let you subtract a month since in January it would crash. How can I achieve what I need? Help please.

Re: Macro Problem: Selecting Previous Month

Gysbert_Wassenaar — Wed, 20 Feb 2013 17:53:55 GMT

You don't have to use a macro. You can add a Select in Field action to the trigger instead. Choose MonthYear as field and try as search string =date(addmonths(today(),-1),'MMM YY').

Re: Macro Problem: Selecting Previous Month

Wed, 20 Feb 2013 18:03:41 GMT

That was the exact solution that I wanted. Thank you very much for your response.

topic Macro Problem: Selecting Previous Month in QlikView

Macro Problem: Selecting Previous Month

Re: Macro Problem: Selecting Previous Month

Re: Macro Problem: Selecting Previous Month