Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
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)