0 Replies Latest reply: Nov 2, 2016 1:52 AM by May Keong RSS

    Monthly data movements using set analysis

    May Keong

      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.