Discussion Board for collaboration related to QlikView App Development.
So i trying to identify when a customer as had a order shipped to them on the same day but with different deliver order numbers
Highlighted in Yellow are the deliveries we want to count becuase that customer recieved more than deliver that day
I've tried various set analysis and Aggr function but i just can't get it to work
Example Pivot Table Output
I am not sure I understand the logic behind picking only the yellow rows. Would you be able to elaborate a little bit more?
All i was trying to do was highlight that customer A on 28th Jan had 4 orders and 28th March had 4 orders
These are are orders i need to count, if customer A has only had 1 delivery on a single day then i am not interested in counting it
So, it seems like something like this should work...
If(Count(DISTINCT [Delivery Header Number]) >= 2, Count(DISTINCT [Delivery Header Number]))
Something like this (Image and sample app attached)