Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to create report to count number of customer buy in last 3 year ?

Hi All

I need to create a report to count how many customer continous buy in last 3 year by GROUP_CLASS ?

I have a filed = Year_n , when = 1 , meaning year= 2014

Now i like to know if customer buy in 2014 2013 2012 , count as 1. and like to know which group have more continous buy customer.

Hope some one can give me the expression.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to create report to count number of customer buy in last 3 year ?

Hi All

Enclosed my QV doc

Paul

Community Browser