Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Monthly data movements using set analysis


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.


0 Replies