Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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
Highlighted
Specialist III
Specialist III

Something like this?

Capture.PNG

Thanks

Highlighted
Master III
Master III

Hi Liana,

why not Customer 91547732 ?

See attachment.

Regards,

Antonio

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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