topic Re: QlikView Filter in QlikView

QlikView Filter

mr_lampert — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: QlikView Filter

sibin_jacob — Mon, 06 Aug 2018 11:50:57 GMT

Click on search icon on the Groupe listbox then type

*B* then enter

it will select all the values having B

Re: QlikView Filter

mr_lampert — Mon, 06 Aug 2018 11:53:38 GMT

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

Re: QlikView Filter

sibin_jacob — Mon, 06 Aug 2018 12:48:29 GMT

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.

Re: QlikView Filter

mr_lampert — Mon, 06 Aug 2018 12:59:25 GMT

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

Re: QlikView Filter

mr_lampert — Mon, 06 Aug 2018 13:17:15 GMT

Works perfect! Thank you very much Sibin

Greetings from Germany