Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Select Multiple Fields less than a value using Macro

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)")

2 Replies
Not applicable
Author

Hi,

You can try like this: 

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

er_mohit
Master II
Master II

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