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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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