Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dynamic Set Analysis Intersect

Hi,

We have a problem with the syntax about Set Analysis "Intersect".

My goal is:

count for every week, the customer that was connected both in the current and previous week.

Thanks in advance to all.

Alessandro

1 Solution

Accepted Solutions
Not applicable

Re: Dynamic Set Analysis Intersect

Ciao Ale,

I guess you probably want to achieve something like this.

You just have to clone the week field creating a data island.

Basically you don't' need set analysis... despite the performance, something like if(MyWeek = Yourweek, count(distinct Customer)) should give you the numbers...

2 Replies
msheraton
Contributor III

Re: Dynamic Set Analysis Intersect

I don't know if you can do that in Set Analysis "Intersect".

An alternative is something like this.  For this to work you would need to add all weeks for every customer.

if( above(count(DISTINCT Customer_ID)) > 0, count(DISTINCT Customer_ID))

Not applicable

Re: Dynamic Set Analysis Intersect

Ciao Ale,

I guess you probably want to achieve something like this.

You just have to clone the week field creating a data island.

Basically you don't' need set analysis... despite the performance, something like if(MyWeek = Yourweek, count(distinct Customer)) should give you the numbers...

Community Browser