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: 
mikelees80
Contributor
Contributor

Set Analysis vs Aggr to find multiple orders in a single day

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

Example Table

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

   

CustomerDelivery Header NumberDelivery Line NumberDelivery DateMonth
A1127th janJan
A1227th janJan
A2128th JanJan
A2228th JanJan
A3128th JanJan
A4128th JanJan
A4228th JanJan
A5128th JanJan
A5228th JanJan
A6129th janJan
A6229th janJan
A7127th marmar
A7227th marmar
A8128th marmar
A8228th marmar
A9128th marmar
A10128th marmar
A10228th marmar
A11128th marmar
A11228th marmar
A12129th marmar
A12229th marmar
B20127th janJan
B20227th janJan
B21128th JanJan
B21228th JanJan
B22128th JanJan
B23128th JanJan
B23228th JanJan
B24128th JanJan
B24228th JanJan
B25129th janJan
B25229th janJan
B26127th marmar
B26227th marmar
B27128th marmar
B27228th marmar
B28128th marmar
B29128th marmar
B29228th marmar
B30128th marmar
B30228th marmar
B31129th marmar
B31229th marmar

Example Pivot Table Output

   

Layout 1
27th jan28th Jan29th jan27th mar28th mar29th mar
CustomerA040040
B040040
layout 2
JanMar
CustomerA44
B44
4 Replies
sunny_talwar

I am not sure I understand the logic behind picking only the yellow rows. Would you be able to elaborate a little bit more?

mikelees80
Contributor
Contributor
Author

Hi Sunny

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

sunny_talwar

So, it seems like something like this should work...

If(Count(DISTINCT [Delivery Header Number]) >= 2, Count(DISTINCT [Delivery Header Number]))

sunny_talwar

Something like this (Image and sample app attached)

Capture.PNG