topic Re: First purchase et Second purchase in QlikView

First purchase et Second purchase

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I have a file containing dates, families of products and customers. I would know about each family the number of customers who ordered a first (minimum date)

I have done this and it's work

sum( {<[ID Customer] = {"=min(Date)"} >} Nb_customer)

and the number of customers who ordered a second time by super family.

sum( {<[ID Customer] = {"=min(Date), [Big Family]={'FORME & BEAUTE'}" } >} Nb_Customer)

the goal is to reach this but with my second calculation everything is at zero

Big Family	sum(Turnover)	First purchase	Second purchase MAISON ET ENTRETIEN	Second purchase BRICOLAGE	Second purchase CUISINE	Second purchase FORME & BEAUTE
MAISON ET ENTRETIEN	646,79245	9	0	0	0	0
BRICOLAGE	689,14223	16	0	3	0	0
CUISINE	3707,0812	33	0	0	6	0
FORME & BEAUTE	11957,26189	148	0	0	0	30

thanks for your help

Re: First purchase et Second purchase

Anil_Babu_Samineni — Tue, 20 Nov 2018 04:07:30 GMT

For me, Quiet syntax wrong. Try this?

sum( {<[ID Customer] = {$(=min(Date))}, [Big Family]={'FORME & BEAUTE'} >} Nb_Customer)

sum( {<Date = {$(=min(Date))}, [Big Family]={'FORME & BEAUTE'} >} Nb_Customer)

Re: First purchase et Second purchase

tresB — Tue, 20 Nov 2018 07:02:07 GMT

Your first expression itself seems to be wrong. When you write - sum( {<[ID Customer] = {"=min(Date)"} >} Nb_customer) that means you are comparing customer ID with a date value, which is potentially wrong. Correct way of writing similar set expression would be something like: sum( {<Date = {'$(Date(min(Date))'} >} Nb_customer)

If you could share a sample app to work on, we could help you better.

Re: First purchase et Second purchase

Anonymous — Tue, 20 Nov 2018 10:12:25 GMT

Hello

You're right, this is what i would like in reality

thanks a lot

Re: First purchase et Second purchase

Anonymous — Tue, 20 Nov 2018 10:37:16 GMT

Sorry,

I was wrong about my calculations, i published a correction

thanks

Re: First purchase et Second purchase

tresB — Tue, 20 Nov 2018 10:38:56 GMT

Like this?

Count( {<Date = {'$(=Date(min(Date)))'}>} Occurrence_Client)

Count( {<Date = {'$(=Date(min(Date,2)))'}>} Occurrence_Client)

Count( {<Date = {'$(=Date(min(Date,3)))'}>} Occurrence_Client)

PFA as well.

Re: First purchase et Second purchase

Anonymous — Tue, 20 Nov 2018 16:41:31 GMT

thanks

it works well on a client

but over a period it does not work.

I have too few results because i have 191 customers

thanks for your help