22 Replies Latest reply: Aug 1, 2017 3:22 AM by Tresesco B RSS

    Multiple Selection in QlikView

    Rui Bao

      Hi, all.

       

      I want to select two columns' records at once. But I don't know how to achieve that.

       

      For example, I have two columns, named 'Seller' and 'Buyer'. And I got some records like below:

      SellerBuyer
      AB
      AC
      BA
      CD
      DE
      EA
      DB

       

      Now, I want to have ONE list box or something, but just one, that can make me to select ABCDE. Then once I select A (or BCDE), the records that contain A (or BCDE) will be filterd and displayed, no matter it is in Seller or Buyer. The results will be like:

      SellerBuyer
      AB
      AC
      BA
      EA

       

      Cause every list box needs a field to create, once I choose Seller as the field, it only shows Seller's records.

       

      So, I want to choose one and select both. How can I make that? Hope I express myself clearly.

       

      Many thanks!