topic Re: Active Customer Calculation in QlikView

Active Customer Calculation

Sun, 13 Oct 2013 08:40:20 GMT

hi i am trying to achieve the following if a customer has bought something the last two years then active if hasnt then inactive

i have the following statement but it is not working as i assumed;

if(Year > max(Year-2),

if(Sum($(vNettoFsg)) > 0, Count(Customer))

please advise.

Best,

Brad

giakoum — Sun, 13 Oct 2013 08:52:17 GMT

Hi.

I would propose that you do this check in the reload script. If it is not possible, please attach a sample application so that I can try on that.

Ioannis.

Sun, 13 Oct 2013 08:54:19 GMT

Hi,

you can use nested set analysis.

Try something like this,

count({<Customer={"=sum({<Year={'>=$(=max(Year)-2)"}>}Sales)>0"}>}Customer)