Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
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...
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))