10 Replies Latest reply: Apr 20, 2017 5:19 PM by Oleg Troyansky RSS

    Multiple Selection Movie Genres

    Marco Giannuzzi

      Hi, I have a problem in QlikSense.

       

      I have the following table

       

      Movie    Genres

      M1    G1|G2|G3

      M2    G1|G4

      M3    G2|G3|G5

       

      My purpose is that, an user can select multiple genres; considering as example:

       

      - I select the genre G1

           The result has all the movies having the genre G1 -> M1,M2,M3

       

      - I select also the genre G3

           The result has all the movies having the genres G1 and G3 -> M1,M3

       

      I tried also SubField(Genres, '|') but nothing...

       

      Any ideas?

      Thanks!