Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Valued Contributor

Re: composite key

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

Re: composite key

Thanks so much for response.

shaimamahmoud
Contributor

Re: composite key

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