Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shabarish0587
Contributor III
Contributor III

How to Display data from selected value greater than using Input Box

Hi Folks,

                I am facing a issue using Input Box. can any one please help me on this. Actually i have few columns like  ID, Date and Days. Here my requirement is i need to enter the values from Input box for days.

                It Means if we give  8 from Input box. it should display all the days data greater than 8 in the chart.

         For Eg: i Have days like 7,8,9,10,11, in Input box if i give 8 then it should display the data  greater than 8 like 8,9,10,11... like that.

            I am sharing sample excel file. Can anyone help me on this. 

1 Solution

Accepted Solutions
rubenmarin

Hi, if you have an input field with vDays set as variable you can use an expression like:

Only({<Days={">$(vDays)"}>} Days)

This can work with a table that uses ID, Date and Priority as dimensions and the proposed expression as the only measure.

View solution in original post

2 Replies
rubenmarin

Hi, if you have an input field with vDays set as variable you can use an expression like:

Only({<Days={">$(vDays)"}>} Days)

This can work with a table that uses ID, Date and Priority as dimensions and the proposed expression as the only measure.

shabarish0587
Contributor III
Contributor III
Author

Thank you Rubenmarin