topic How can I do this selection? in QlikView

How can I do this selection?

rcandeo — Mon, 22 Jun 2009 20:48:42 GMT

I have a macro used to select actual month and year in my application:

ActiveDocument.GetField("Month").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'MM')")

It was working, till I defined my Month field properties to integer.

Can anyone help me fixing this function?

How can I do this selection?

Mon, 22 Jun 2009 21:53:43 GMT

I'm guessing this should work:

ActiveDocument.GetField("Month").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'M')")

I did a quick test and 05 is different from 5. If I use your original expression, I can select months stored as 05. If I remove one of the Ms, it won't select 05, but it will select 5. I'd check how you're early months look, I'm guessing they don't have the leading zero.

How can I do this selection?

rcandeo — Mon, 22 Jun 2009 23:10:50 GMT

It worked, but I am worried about last three years of the month: 10, 11, 12. Do You Think will it work?

How can I do this selection?

Mon, 22 Jun 2009 23:20:38 GMT

Yes, those would have worked with either expression. One M means one number for the earlier months, but would still display as two numbers for October and later.

You could probably amend your expression to select a later month, by changing the parameter of the addmonths function to test it out. EDIT: I did addmonths(date, 5) for both MM and M and it selected 11.

How can I do this selection?

rcandeo — Mon, 22 Jun 2009 23:21:12 GMT

Forget, I've found a way to test and it worked again. Thank You