2 Replies Latest reply: Oct 26, 2012 7:19 AM by Dennis Hoogenboom RSS

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

      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

       

      Place

      person1

      person2

      name

      nameagenameage
      beachtoto25tarzan32
      streetjane32john50
      officemike42

       

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

       

      Place-name

      person1-nameperson1-ageperson2-nameperson2-age
      beachtoto25tarzan32
      streetjane32john50
      beachmike42

       

      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