Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
Contributor III
Contributor III

2 measures 2 dimensions on a combo chart

Hi All,

Simplified data structure as described below

I have data about moves on a vessel. This shows a row for each move, a movedatetime and a VesselID.

I have a vessels table which shows a VesselID, its ATA (actual time arrived) and ATD (actual time departed).

I then have data around truck in a separate table, it shows truckdatetime and a TruckID.

What I want to be able to do is select a VesselID, use the ATA and ATD as my timeframe and show count of TruckID as bars over movedatetime and a count of Vesselover the same timeframe. 

There is no canonical calendar.

Essentially I want something like the attached.

Any help would be great!

Thanks

Labels (1)
1 Reply
lorenzoconforti
Specialist II
Specialist II

It might be feasible; can you post some sample data in Excel/qvf?