Discussion Board for collaboration related to Creating Analytics for QlikView.
I have customers in serveral channels. Each channel is a different field.
I want to do a set analysis where I can choose a channel. I've created a data island where I can select a channel but I can't get it right in my set analysis.
The tricky part is that the name of the channels in my data island is are different than the fields.
It worked with triggers but the solution is not elegant 🙂
Define variable like:
Thx that's a lot easier.
But how can select 2 channels. A customer who has been contacted by phone and mail.
I joined my data island with itself so I get n² combinations. Made a second variable vChannel_2 an changed your expressions.
Is it possible with only one field in my data island and use alternate states?
vChannel = Only(If(WildMatch($Field,'*'&Channel&'*'),$Field))
vChannel_2 = Only(If(WildMatch($Field,'*'&Channel&'*'),$Field)) from an alternate state