Want to see count of different activities performed on Same date

[tvbinoj]

We have multiple activities performed on same day for multiple orders. Please see attached excel sample. Would like see all activities in one chart in qlik. Appreciate if you can help me to create this chart in qlik as I am new to qlik.

Binoj

[Marijn]

Hi @tvbinoj 

I think you could do it like this:

main:
load
   count([Order Number]) as [No. of bookings],
   [Booking Date] as Date
resident Data
group by [Booking Date];

outer join (main) load
   count([Order Number]) as [No. of Sent],
   [Sendind Date] as Date
resident Data
group by [Sendind Date];

outer join (main) load
   count([Order Number]) as [No. of Arrivals],
   [Arrival Date] as Date
resident Data
group by [Arrival Date];

drop table Data;