Input Box should give required records

Thu, 11 Dec 2014 09:46:11 GMT

Hi all,

i have a requirement with the input box. i have orders, order received date, order finish date,target hrs to finish the order and Actual No.of hrs to complete the orders as fields.

In this case Target hrs are 4.

Actual No. hrs are 0-99 hrs.

Now in an input box, when i enter actual 3hrs the table should show all the records 0-3 and

if i enter actual 5hrs the table should show all the records 0-5.

can someone please suggest me how to achieve this requirement.

Thanks

Regards,

Sridhar

Re: Input Box should give required records

Anonymous — Thu, 11 Dec 2014 09:51:47 GMT

Hello,

Assign this inputbox to a variable. And then filter your chart with the variable in a set expression. Something like (may not be exact):

sum ({<hour={<=$('myVariable')}>}ORDERS)

Serhan

topic Re: Input Box should give required records in QlikView

Input Box should give required records

Re: Input Box should give required records