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

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

shabarish0587 — Wed, 24 Mar 2021 15:12:42 GMT

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.

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

rubenmarin — Thu, 25 Mar 2021 07:41:48 GMT

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.

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

shabarish0587 — Fri, 26 Mar 2021 07:30:36 GMT

Thank you Rubenmarin