topic Re: Dynamic Set Analysis Intersect in QlikView

Dynamic Set Analysis Intersect

Tue, 04 Dec 2012 11:24:13 GMT

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

Re: Dynamic Set Analysis Intersect

RedSky001 — Tue, 04 Dec 2012 14:04:45 GMT

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))

Re: Dynamic Set Analysis Intersect

Tue, 04 Dec 2012 20:32:04 GMT

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...