topic Re: How to combine multiple fields in a listbox? in QlikView

How to combine multiple fields in a listbox?

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I have a source table like this:

and want to have a listbox as a filter like this:

Animals

------------

dogs

cats

horses

rabbits

...

so that it returns all employees with cats, if I press cats in that listbox.

I tried it with

=if(cats='x',dual('cats',1),

if(dogs='x',dual('dogs',2),

but this ended up in garbage

any idea?

sunny_talwar — Wed, 20 Jul 2016 13:56:23 GMT

Have you thought about using CrossTable Load?

Wed, 20 Jul 2016 14:02:27 GMT

Hi,

You need use cross table.

Load your source table then advance -> advance and do this:

After that press ok and reload.