QlikView Filter

[mr_lampert]

Hey Community,

I want to filter the field 'Groupe'. If the field 'Groupe' is set as Listbox, I can easy filter my values.

BUT!

Is there a possibility that in the list box all possible values appear only once and then with a click on a letter all lines are activated, in which this letter is contained?

So in this example I created a field names 'Filter'. If 'B' is activated the rows 3 and 5 are the only one left, because there contained the letter in the filter.

[sibin_jacob]

Click on search icon on the Groupe listbox then type

*B* then enter

it will select all the values having B

[mr_lampert]

Hello Sibin,

yes, I know But I want to make this simple for the user, so he should use a Listbox that should looked like the listbox 'filter'. That`s the problem

Greetings,

Dave

[sibin_jacob · Accepted solution]

I am assuming, you created filter column, which is not connected to the Groupe Column table.

You need to create a trigger to achieve this functionality.

For testing.

1. Create a text box then add an action

2. select In field

3. Field as Groupe

4. search string write as below

=$(Vtest)

5. create a variable name Vtest

6. write the definition as below

=chr(39) &'*' & Filter &'*' & Chr(39)

If you select value 'B' in the Filter listbox then click on the text object, it will select all the 'B' contain values in the Groupe listbox and also filter the table.

If it is working fine, you can add the same trigger into , field trigger or OnAnySelect trigger in the 'document' properties.

[mr_lampert]

OK I try what asap! I'll contact you soon with feedback!

[mr_lampert]

Works perfect! Thank you very much Sibin

Greetings from Germany