4 Replies Latest reply: Nov 6, 2012 11:26 AM by russells1 RSS

    Creating a List Box of Field Headers from Flag/Indicator Fields

      I have some data to load where there are five Y/N flag fields.  How can I create ONE List Box that shows the 5 Field Names (rather than Y or N) and allows multiple options to be selected?  Example Data:

       

      NameTennisFootballSquashCyclingAthletics
      BobYYNYN
      BillNNNYN
      SimonYYYYN
      JamesYNYYN
      JaneNNYYN

       

      Once in Qlikview I would like a List Box that lists the sports eg:

       

      Sport
      Tennis
      Football
      Squash
      Cycling
      Athletics

       

      So if 'Football' was selected, my Chart/Table would show Bob & Simom.  And if 'Football' AND 'Tennis' was selected I would be Bob, Simon & James.

       

      (The data actually has a a load more Flag fields and other columns, so I don't want to load as a CrossTable as figured that would be slow and inefficient)

       

      Thanks for your help!