topic Re: How to have one listbox for querying multiple fields (logical OR beetwen)? in QlikView

How to have one listbox for querying multiple fields (logical OR beetwen)?

Fri, 26 Oct 2012 09:45:02 GMT

Hi All

I am quite new to QlikView and with my colleague we are trying to have a list box for querying multiple fields, without success.

Perhaps you are more experienced, and you may help :

First we have a QlikView document and the data come from a Excel sheet

The Excel sheet has two headers because it is possible to have multiple object of the same nature, for example

We decided to simplify the file to a sigle header file:

And then we created a QlikView document from this file

What we are trying to do now is to filter by age.

For exemple we want all place names that are frequented by at leat one person of 32 years old

for example : 32 will give : street and beach

Unfortunately when we create a list box, it is linked to one single field ? But what we want here is to query multiple fields with a logical OR.

Any suggestion about how we can achieve that? What is the right way to do?

Hope it is clear enough

Thanks in advance

Anonymous — Fri, 26 Oct 2012 11:01:55 GMT

If you can want to have two columns, you should be able to create this table with two header rows using a pivot table.

In the script add a PersonNum field to your Persons table to say whether will appear in column 1, 2 ... n.

On the pivot chart:

First dimension = PlaceName

Second dimension = PersonNum (the column identifier)

First expression = only(PersonName)

Second expresison = only(Age)

You could then drag and drop dimension 3 (PersonNum) onto horizontal header to show person-1 or person-2 etc. columns.

Anonymous — Fri, 26 Oct 2012 11:19:11 GMT

There are different ways to do this.

I would prefer to seperate the personnumber into a new field

In other word create data like this:

I attached an example of one way to do this.

Is this what you are looking for?

Good luck.

Dennis.