Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 |
Something like this?
Thanks
Hi Liana,
why not Customer 91547732 ?
See attachment.
Regards,
Antonio
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
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
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!!!
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