'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

[sinanozdemir]

Can you provide sample data for your scenario?

[Anil_Babu_Samineni]

Count({<Product = {"A"}>}Customer_ID) OR Count({<Product = {"B"}>}Customer_ID)

[#4]

Hello Mr. Ozdemir,

this is the first time I have posted a question. I can`t find the way to upload the QVW Data

Making  some Mistakes.

Thanks Liana

[#5]

Hello Mr. Babu,

your syntax is helpful, but I also need to consider the OrderDate. Group by Costumer only when the OrderDate for Product A the same or one day later as for Product B is.

Thanks. Best Regards. Liana

[vishsaggi]

May be this?

IF(OrderDate = Today(), Count({< Product = {'A'}>} Customer_ID), Count({< Product = {'B'} >})

[Anil_Babu_Samineni]

Liana, Still confused what you are expecting,

If you got any help from this Thread please put flag Mark as Helpful

[#8]

Hello Vishsaggi,

the OrderDate are all in the past. I think that is why OrderDate=Today() is not working.

Who can I upload the QVW Data?Thanks

[antoniotiman]

Hi Liana,

If I have understood correctly, like this

[#10]

Hello Mr. Babu

the data look like these.  I am still searching for the flags to mark these helpful answers

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