topic Re: Advanced Set Analysis in QlikView

Advanced Set Analysis

Fri, 29 Jan 2016 16:49:52 GMT

Please see this data table:

Brand	Item	Customer	Month
Eggo	Blueberry	Ryan	Jan
Eggo	Blueberry	Ryan	Feb
Waffle House	Blueberry	Ryan	Mar
Eggo	Strawberry	Ryan	Mar

I would like to write an analysis that gives me a count of Customers, By Month where the Customer switched the Brand but hanged on to the Item. For example in the Month of March Ryan switched to Waffle House but stayed with Blueberry item.

Thanks.

Re: Advanced Set Analysis

Gysbert_Wassenaar — Fri, 29 Jan 2016 18:34:50 GMT

And how do you handle two simultaneous changes?

Eggo/Blueberru->Waffle House/Blueberry + Eggo/Blueberry->Eggo/Strawberry

Re: Advanced Set Analysis

Fri, 29 Jan 2016 18:39:02 GMT

We will not handle simultaneous changes. It will be always the first start within the time period selected. The base will always begin with Eggo. That will never change.

Re: Advanced Set Analysis

Fri, 29 Jan 2016 19:01:36 GMT

I believe its easy to add the flag on the script level instead of set analysis if you data granularity is on Month level.

Set analysis won't work on the row by row comparison.