composite key

[#1]

Hello Everyone,

Please help me.

I have following tables and fields;

max_stock:

MainVesselTypeId,

MainVesselId,

stock

Vessel:

VesselId,

    Name      ///  vessel name

VesselType:

VesselTypeId,

    TypeName   // vessel type name

Now, I want to create composite key connecting MainVesselTypeId with VesselTypeId and MainVesselId with VesselId and want to display vessel type name, vessel name and vessel stock. How can I do this using composite key.  Here, I cannot/do not want to use Apply Map function.

Please help me .

Thank You,

Rahul Krishan Goyal

[Anonymous]

You shouldn't need a composite key as you are linking a single table to a single field, if you rename VesselID and VesselTypeID then both tables (Vessel and VesselType) will be linked to max_stock.

max_stock:

MainVesselTypeId,

MainVesselId,

stock

Vessel:

VesselId as MainVesselId,

Name      ///  vessel name

VesselType:

VesselTypeId as MainVesselTypeId,

TypeName   // vessel type name

[#3]

Thanks so much for response.

[Anonymous]

You have to make the relation columns have the same name and the join will work automatically in Qlik sense as Bella done in the script

your tables of MaxStock, Vessel , VesselType will be joined as they are one table automatically,

but also they are still three tables.

Good Luck