'how many customers ordered product a on the same day and/or one day later as product b?'

[#1]

Hello,

I have made only easy aggregations in QlikView so far. This problem is a big fish for me

I need the number of customers who ordered product A on the same day and/or one day later as product B.

Three Columns: Customer_ID, OrderDate, Product

I would really appreciate you help.

Best Regards. Liana

[#2]

Hello Mr. Mancini,

almost

the question is when the same customer ordered both product a and product b on the same day or one day later. The Data look like this:. Thanks for your interst.

Customer	OrderNr	OrderDate	Product	Quantity
87595694	56425594	15.04.2016	A	2
90505091	56460521	23.05.2016	B	3
90505091	56460869	24.05.2016	A	2
91547732	56464059	27.05.2016	B	3
91547732	56464671	27.05.2016	A	2
91577546	56435552	11.05.2016	N	2
91577546	56488960	22.06.2016	A	2
92556467	56447810	09.05.2016	N	3
94583836	56456078	19.05.2016	I	3
94583836	56473408	05.06.2016	B	3
94583836	56474165	06.06.2016	A	2
96715470	56415503	06.04.2016	B	3
96715470	56419187	11.04.2016	B	3
96715470	56420874	11.04.2016	A	2
96827229	56418014	08.04.2016	A	2

[sinanozdemir]

Something like this?

Thanks

[antoniotiman]

Hi Liana,

why not Customer 91547732 ?

See attachment.

Regards,

Antonio

[#5]

Hello Antonio,

your answer and the one from Sinan are both right. Thanks a lot! This program is powerful!

My next question is, of course, your syntax. It seems to be an expresion and not some Script manipulation.

Best Regards Liana

[#6]

Hello Sinan,

your answer and the one from Antonio are both right. Thanks a lot! This program is powerful!

My next question is, of course, your syntax. It seems to be an expresion and not some Script manipulation.

Best Regards Liana

[#7]

Hello Sinan,

your way to Rome and the one from Antonio have expanded my interest und my little knowledge enormously.

Different approaches, material to think about.

The problem is solved.

Thanks a lo t!!!

[#8]

Hello Antonio,

I could not see the Attachment bevor.

Have to look longer and analyze the syntax carefully. I am really motivated.

Both your way and the one from Sinan solve the problem.

It is my first experience at the community. It is a very good one.

Thanks a lot!!!

Liana