topic Re: filtering records in straight table based on user value in QlikView

filtering records in straight table based on user value

Tue, 10 Dec 2013 04:06:27 GMT

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

Re: filtering records in straight table based on user value

valerio_fatatis — Tue, 10 Dec 2013 05:35:32 GMT

HI,

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

Re: filtering records in straight table based on user value

brijesh1991 — Tue, 10 Dec 2013 05:50:15 GMT

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)