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
Can you provide sample data for your scenario?
Count({<Product = {"A"}>}Customer_ID) OR Count({<Product = {"B"}>}Customer_ID)
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
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
May be this?
IF(OrderDate = Today(), Count({< Product = {'A'}>} Customer_ID), Count({< Product = {'B'} >})
Liana, Still confused what you are expecting,
If you got any help from this Thread please put flag Mark as Helpful
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
Hi Liana,
If I have understood correctly, like this
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 |