topic Re: set analysis on a variable triggered by data island in QlikView

set analysis on a variable triggered by data island

kristof_j — Fri, 06 Jun 2014 09:19:13 GMT

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 🙂

Re: set analysis on a variable triggered by data island

tresB — Fri, 06 Jun 2014 09:37:46 GMT

Define variable like:

vChannel =Only(If(WildMatch($Field,'*'&Channel&'*'),$Field))

Re: set analysis on a variable triggered by data island

kristof_j — Fri, 06 Jun 2014 11:37:47 GMT

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