2 Replies Latest reply: Jun 12, 2018 8:56 AM by Todd Buss RSS

    Qlik Sense: selecting from a sequence

    Todd Buss

      I have a beginner question that's probably been asked and answered a thousand times already.  If someone has  a link to examples, I would be grateful.  As a non-SQL user, I lack the vocabulary to elucidate my question well.

       

      My simplified example table

      Owner,Sequence,Pet

      Alice,1,cat

      Bill,1,dog

      Charles,1,fish

      Charles,2,hamster

      Charles,3,cat

       

      In the dashboard, a user selects "cat" to see all the cat owners (Alice and Charles).

      I want to display all the fish owners and all their pets.

       

      What I'm getting:

      OwnerSequence 1Sequence 2Sequence 3
      Alicecat----
      Charles----cat

      * from this, I know I have 2 cat owners and they are Alice and Bill, but "fish" and "hamster" are NOT selected, so they are not displayed.

       

      What I want:

      OwnerSequence 1Sequence 2Sequence 3
      Alicecat----
      Charlesfishhamstercat

      I suspect I need to transform my data during load  to make it work as planned.  Create a field called "cat owner(Y/N)" for every record, but there are lots of different pets and this doesn't seem like a good practice.  I didn't post my original code because it's confusing, involving both categories and sequences for each "pet"

       

      thanks.