topic Re: Composite Key in QlikView

Composite Key

rathnam_qv — Wed, 18 Sep 2013 09:02:48 GMT

Hi all,

i hv three common keys in three tables (like:ranjit,ram,murali)..then how to create cmoposite keys...can any one hepl me....urgent

Thanks in advance!!!

Smiley

MK_QSL — Wed, 18 Sep 2013 09:04:13 GMT

You can use in script like below......

FirstName&" "&MiddleName&" "&Last Name

Wed, 18 Sep 2013 09:07:48 GMT

Hi Rathnam,

Composite key means combination of two or more fields will be used as a key.

For example,

Table A , Table B, consider the relation between the two tables are country, customer and salesperson.

You can create the key as country&'-'&Customer&'-'&Salesperson as KEY.

Sometimes you may need to add the date field also in the key based on the req as well as data modelling.

Wed, 18 Sep 2013 09:09:27 GMT

suppose you have three common field like A, B, C are common in Three tables.

then if you want to make composite key then in each table write this code

A & B & C as new_key

preminqlik — Wed, 18 Sep 2013 09:30:15 GMT

Create composite key in three tables

eg:

fieldName1&'separator'&fieldname2&'separator'&feildname3

for example

CusID&'-'&Location&'-'&Postion as [Cus_Loc_Pos key]

here the separator is for developer understanding you can use any symbol in that.