Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
mr_lampert
Contributor III
Contributor III

QlikView Filter

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.

Bild2.png

1 Solution

Accepted Solutions
sibin_jacob
Creator III
Creator III

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.

View solution in original post

5 Replies
sibin_jacob
Creator III
Creator III

Click on search icon on the Groupe listbox then type

*B* then enter

it will select all the values having B

mr_lampert
Contributor III
Contributor III
Author

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
Creator III
Creator III

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.

View solution in original post

mr_lampert
Contributor III
Contributor III
Author

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

mr_lampert
Contributor III
Contributor III
Author

Works perfect! Thank you very much Sibin

Greetings from Germany