topic Concatenated key in QlikView

Concatenated key

Thu, 14 Aug 2014 10:41:49 GMT

Hi,

Can anyone explain me what is the use of concatenated key and why it is used?

(i.e) cust_id & store_id & invoice_id as %key_id

Regards,

Logesh

Re: Concatenated key

Gysbert_Wassenaar — Thu, 14 Aug 2014 10:48:25 GMT

You can find some uses in this document: Generic keys

Re: Concatenated key

Thu, 14 Aug 2014 10:52:08 GMT

You create a uniq key between tvo tables. In your example I guess that same inovice id and cust id can exist in diffrent stores. By adding the store id and cust id you create a uniq key that ties data in diffrent tables togheter.

Re: Concatenated key

SunilChauhan — Thu, 14 Aug 2014 10:53:22 GMT

some times we are not able to differenciate b/w two tables based on one key. in fact

spme times we need to find the data matching from two tables and not able to find based on one key

then we can concatenate key and they find it

for eample

Emp Department sales

123 10 200

123 20 300

hope this helps

Re: Concatenated key

Thu, 14 Aug 2014 11:13:08 GMT

Hi,

i found ur answer was helpful.by using this key (cust_id & store_id & invoice_id as %key_id) if i want to create a chart with x axis as cust_id and y axis as sum(sales) then how do i?

Do i need to use subfield function to fetch cust_id like tat??