topic Macro to Actions Issue (Last 12 Months select ) in QlikView

Macro to Actions Issue (Last 12 Months select )

Wed, 28 Jul 2010 21:49:09 GMT

We are in process of migrating QV report from Version 8.2 to 9. When we move report to version 9, we want to eliminate macros as much as possible. So far I am able to produce desired behavior using "Actions" and removing macros. However I am having trouble in converting following macro to actions in version 9.

sub Lock

set y=ActiveDocument.GetField("Date")

y.TOPSelect "Date",12

end sub

How do I make sure search string always selects last 12 months?

Macro to Actions Issue (Last 12 Months select )

Anonymous — Thu, 29 Jul 2010 05:22:16 GMT

Here's an example using Actions instead of a macro to select the last 12 months from a YearMonth field.

Macro to Actions Issue (Last 12 Months select )

Mon, 07 Feb 2011 16:14:56 GMT

How do I select the last twelve months.

My formula is:

='>' & date(addmonths((date(Today(),'YYYY')&MaandMin1-1),-12), 'YYYYMM')

He selects the last month when I use the formula

=(date(Today(),'YYYY')&MaandMin1-1)

But he was nothing when I select the entire formula

Who can help me with this?

Macro to Actions Issue (Last 12 Months select )

Mon, 07 Feb 2011 16:26:06 GMT

I am using following formula and it is working fine for me. Can you try it ?

= '>' & MonthStart((Today()),-12)

Macro to Actions Issue (Last 12 Months select )

Mon, 07 Feb 2011 16:37:01 GMT

don't work by me

Macro to Actions Issue (Last 12 Months select )

Mon, 07 Feb 2011 16:39:01 GMT

=(date(Today(),'YYYY')&MaandMin1-1)

This one works, but i want the past 12 months