topic Re: Calculate returning customers in QlikView

Calculate returning customers

davidg_curs — Fri, 14 Oct 2016 11:51:08 GMT

Hi,

Please help.....

I want to calculate how many products bought return customers from last year in this year, regardless SALES_AGENT.

Should be 7 products... I can't figure out how to use SET analysis 😞

Thanks!

johnw — Fri, 14 Oct 2016 17:17:20 GMT

Maybe this?

count({<CUSTOMER_ID=P({1<YEAR={2015}>})>} PRODUCT)

davidg_curs — Sun, 16 Oct 2016 11:51:14 GMT

Hi John,

thanks for the answer. It gives me the correct result.

I also try:

=Count({<YEAR = {'2016'},

CUSTOMER_ID={"=COUNT({<YEAR = {'2015'}>}PRODUCT)>0"}

>} PRODUCT)

which is also one of the solutions.