Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple selection - listbox

Hello!

I was asking to something similar here: Re: Listbox search in more than one field

I have the following fields in a table:

QV1.png

I'd like to have a listbox searching among all those fields, displaying all possible values (only once per value):

Listbox:
2

7

37

10

14

15

37

but with an "and" expression. I mean, If I select 14 and then 37 and 38, it displayed me rows that with those three values. Is it possible??

thanks in advance

1 Reply
swuehl
MVP
MVP

Maybe like this:

Transform your cross table to a straight tabe using CROSSTABLE LOAD prefix. Then prepare another table to enable the AND mode list box in the frontend:

INPUT:

LOAD * INLINE [

ID, Code1, Code2, Code3

1, 1,2,3

2, 3,3,4

3, 4,5,6

4, 2,1,5

];

Link:

CROSSTABLE (CodeNo, Code)

LOAD * RESIDENT INPUT;

SELECT:

LOAD DISTINCT ID, Code as AndSelect RESIDENT Link;

2017-02-09 21_45_40-QlikView x64 - [C__Users_Stefan_Downloads_comm249355.qvw_].png