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
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

composite key

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


3 Replies
bellamae
Specialist
Specialist

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

Not applicable
Author

Thanks so much for response.

shaimamahmoud
Creator
Creator

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