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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get a value from a table to a Variable

Hello,

I'm having a table with the values

FilmWeek Year, FilmWeek WeekNbr, FilmWeek YWeek, FilmWeek PrevWeek Year, FilmWeek PrevWeek Week

I'm having listboxes in filmweek year, filmweek weeknbr, and would need the Yweek and the prevweek year & weeknbr into variables, so that i can use these variables in a set-analysis.

But can't find a way to set them without a macro.

Kind regards, Harry

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If I understand your problem correctly, you shouldn't need to get the values in variables for use in a Set Expression. You should be able to refer to them directly like

$(=Only(Yweek))

View solution in original post

2 Replies
prieper
Master II
Master II

Do not know, whether it is the best way, but I would create an inputbox for a variable, enter required formulae under Settings and then hide this box somewhere. Hence you have a variable, having always an updated value (which you may also see physically and/or overwrite during the testing)

HTH
Peter

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If I understand your problem correctly, you shouldn't need to get the values in variables for use in a Set Expression. You should be able to refer to them directly like

$(=Only(Yweek))