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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Lawrence
Contributor III
Contributor III

Set Analysis Consisting of a Less Than Equal To and a Variable

Greetings All,

I am looking to make a more dynamic table that alters based off of a slider provided to the user. I currently have a variable set up (vHoursCompleted) which it's value is set by default to 2, but can be changed by the slider anywhere from 1 to 10. An old set analysis line I wrote used to display the counts of all interviews that took 2 hour or less, written as such:

count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=2"}>} InterviewID)

However, I would now like to remove the "2" and input the variable vHoursCompleted so the set analysis will update with the choice of the reader, via the slider. How would I go about inputting the variable in the set analysis, as well as keep the <= ? 

Labels (4)
1 Solution

Accepted Solutions
Christopher_Lawrence
Contributor III
Contributor III
Author

Found the resolve! Dug around in older posts, but for those who may wanna know:

 

count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=$(=vHoursDone)"}>} InterviewID)

View solution in original post

1 Reply
Christopher_Lawrence
Contributor III
Contributor III
Author

Found the resolve! Dug around in older posts, but for those who may wanna know:

 

count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=$(=vHoursDone)"}>} InterviewID)