topic Re: records in table Box as per input value in QlikView

records in table Box as per input value

Wed, 25 Nov 2020 16:16:04 GMT

I want to display records in table Box as per input value in Input Box. How to do it ?

Re: records in table Box as per input value

vishsaggi — Sat, 29 Jul 2017 15:32:20 GMT

You cannot use the inputbox in table box. You have to use a straight table. Table box can take only fields variables are not possible. However, i assume you are trying to add different values into a field ? Correct me? If Yes, you might want to use an InputField where you can change and add the values in each cell.

For eg:

INPUTFIELD Value;

Table:

LOAD * INLINE [

ID, Value

];

Once you load this add these fields in your table box then you can manually enter your own values in individual cells accordingly. So when you hover over your mouse on these individual cells you will get a small button to edit the cell.

Hope this helps.

Re: records in table Box as per input value

passionate — Sat, 29 Jul 2017 18:09:13 GMT

Hi Nitesh,

Please specify your requirement in detail

Regards,

Pankaj

Re: records in table Box as per input value

passionate — Sat, 29 Jul 2017 18:18:21 GMT

This can be tried using variable trigger.

Assign variable to input box and then try to reduce field based on this.

Re: records in table Box as per input value

Sun, 30 Jul 2017 08:18:25 GMT

I want to filter my data by giving input to input box.

for Example -

I have 2 records in database table as below-

eid ename dept

1 A 10

2 B 20

3 C 10

i use one input box for using as deptno, when i enter 10 then all the record who has only dept=10 must display.

How to achieve it.

Re: records in table Box as per input value

vishsaggi — Mon, 31 Jul 2017 15:18:12 GMT

You have to use a trigger to do this.

Click ctrl+Alt+D - Triggers Tab - > Variable Event Trigger -> Onchange Edit button -> Add Select in Field trigger -> use Dept as your field and in search string use your variable name like = vDeptValue.

Re: records in table Box as per input value

Colin-Albert — Mon, 31 Jul 2017 15:24:56 GMT

Why not just add a listbox to your sheet on the dept field. There is no need to use an input box to filter your data.