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: 
Not applicable

String value in a select statement VBA



How can i get the "strValue" in the place of the 38.

I need to make a selection with i from last week until te the first week.

"<38" works

(< strValue) gives a faillure.

Sub setWeektotnuToe()
set v = ActiveDocument.Variables("HuidigeWeek")
strValue = v.GetContent.String
ActiveDocument.Fields("Week").Select "<38"
End Sub

1 Solution

Accepted Solutions
Not applicable
Author

Sub setWeektotnuToe()
set v = ActiveDocument.Variables("HuidigeWeek")
strValue = v.GetContent.String
ActiveDocument.Fields("Week").Select "<"+(strValue)

End Sub







Is the sollution

Bye





View solution in original post

1 Reply
Not applicable
Author

Sub setWeektotnuToe()
set v = ActiveDocument.Variables("HuidigeWeek")
strValue = v.GetContent.String
ActiveDocument.Fields("Week").Select "<"+(strValue)

End Sub







Is the sollution

Bye