topic How to select last week through Macro ? in QlikView

How to select last week through Macro ?

suniljain — Thu, 09 Sep 2010 07:52:15 GMT

Suppose my current week is 36 . I want to select last week through macro.

week field is WORK_WEEK.

How to select last week through Macro ?

Thu, 09 Sep 2010 08:53:21 GMT

Hi Sunil,

if you wanna select current week first you must create a variable CurrentWeek (you can name it whatever you want): =week(Now()) . And the macro will be:

sub SelectWeek

set v = ActiveDocument.Variables("CurrentWeek")

ActiveDocument.Fields("WORK_WEEK").Select v.GetContent.String

end sub

Stefan

How to select last week through Macro ?

suniljain — Thu, 09 Sep 2010 09:36:51 GMT

done

ActiveDocument.Fields(

"WORK_WEEK"). Select ActiveDocument.Evaluate("LastWeek"

)

How to select last week through Macro ?

tresB — Thu, 09 Sep 2010 09:42:55 GMT

Hi,

I would prefer Trigger for the same. Its good to avoid macro !