topic Re: Multiple selection - listbox in QlikView

Multiple selection - listbox

Anonymous — Thu, 09 Feb 2017 20:05:10 GMT

Hello!

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

I have the following fields in a table:

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

Listbox:
2

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

Re: Multiple selection - listbox

swuehl — Thu, 09 Feb 2017 20:46:03 GMT

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;