topic Re: Select Multiple Fields less than a value using Macro in QlikView

Select Multiple Fields less than a value using Macro

Anonymous — Thu, 22 Aug 2013 00:50:32 GMT

I'm trying to select all values in a specific field that are less than the current week using a macro. How would I accomplish this by using this statement?

ActiveDocument.Fields("Week").Select("(1|2)")

Re: Select Multiple Fields less than a value using Macro

Thu, 22 Aug 2013 06:30:04 GMT

Hi,

You can try like this:

ActiveDocument.Fields("Week").Select ">=" & 1 & "<=" & 2

Re: Select Multiple Fields less than a value using Macro

er_mohit — Thu, 22 Aug 2013 06:36:13 GMT

have you tried in Select field using macro add action -->Select field

In select Field write Field name i.e Week

and in search string write (1|2)

hope it helps