Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

16 Replies
Not applicable
Author

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.

  

CustomerOrderNrOrderDateProductQuantity
875956945642559415.04.2016A2
905050915646052123.05.2016B3
905050915646086924.05.2016A2
915477325646405927.05.2016B3
915477325646467127.05.2016A2
915775465643555211.05.2016N2
915775465648896022.06.2016A2
925564675644781009.05.2016N3
945838365645607819.05.2016I3
945838365647340805.06.2016B3
945838365647416506.06.2016A2
967154705641550306.04.2016B3
967154705641918711.04.2016B3
967154705642087411.04.2016A2
968272295641801408.04.2016A2
sinanozdemir
Specialist III
Specialist III

Something like this?

Capture.PNG

Thanks

antoniotiman
Master III
Master III

Hi Liana,

why not Customer 91547732 ?

See attachment.

Regards,

Antonio

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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!!!

Not applicable
Author

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