Monthly data movements using set analysis

Anonymous — Sat, 16 Nov 2024 10:17:05 GMT

Hi,

My data is at a monthly customer level. I would like to track customer movements between groups. How do I do this using set analysis?

Sample data:

SnapshotMonth, Cust_ID, Segment

Mar-2016, 1, Mass

Mar-2016, 2, Mass

Mar-2016, 3, Affluent

Mar-2016, 4, Mass

Mar-2016, 5, Affluent

Mar-2016, 6, Mass

Jun-2016, 1, Mass

Jun-2016, 2, Affluent

Jun-2016, 3, Affluent

Jun-2016, 4, Established

Jun-2016, 5, Established

Jun-2016, 6, Affluent

I want my table to show segment movement between Mar to Jun

Mass -> Mass, 1

Mass -> Affluent, 2

Mass -> Established, 1

Affluent -> Affluent, 1

Affluent -> Established, 1

I had the data Joined so it was on one row eg

Mar-2016, 1, Mass, Jun-2016, 1, Mass

Mar-2016, 2, Mass,Jun-2016, 2, Affluent

however, this is inefficient. It doesn't allow the flexibility of comparing different months unless all combinations are loaded.

Each month's dataset has about 2.5 million records. And the table has 100 columns. The QVD files are large and qliksense is showing slow performance in loading data and loading visualisations.

thanks.

topic Monthly data movements using set analysis in App Development

Monthly data movements using set analysis