Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
kristof_j
Contributor II

set analysis on a variable triggered by data island

Hi

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 🙂

2 Replies
MVP
MVP

Re: set analysis on a variable triggered by data island

Define variable like:

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

kristof_j
Contributor II

Re: set analysis on a variable triggered by data island

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