filtering records in straight table based on user value

[#1]

Hi Guys,

The rows in the staright table should be filtered based on user input value in the Exception button.Please find the attached snapshot for your reference.

You can find a exceptions button(under the text object Stock OPT) which is nothing but an input box where the user can input the values and below there is staright table(under the text object StockOPT)  which should get filtered based on user input.

Eg : If the user enters 70 as an input  it should filter the records in the straight table and should display only the values whose stock opt%>70 and corresponding shortage(MT) values.

As iam new to qlikview,kindly help me out in solving this.

Thanks,

Hari

[valerio_fatatis]

HI,

you can use the appropriatly variable in the input box for control the expression or use the input Field.

[brijesh1991]

create a variable;

Take that variable into an inputbox;

In your straight table or your textbox whereever you want to replicate the change mentioned in your input box, user set analyis:

For Example: count({Opt%={'>$(variable)'}}ID)