Multiple Selection Movie Genres

[Anonymous]

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!

[Oleg_Troyansky]

Found this in the forum, I think it's quite helpful:

And-Mode: How to enable AND and NOT selections with Green, White, Grey...and Red!