topic Re: Key in qlikview in QlikView

Key in qlikview

Anonymous — Mon, 19 Jan 2015 06:27:34 GMT

Hi ,

what is a key in qlikview ?How it is related to link table .please explain with sample example

Thanks

Re: Key in qlikview

jagan — Mon, 19 Jan 2015 06:33:31 GMT

Hi,

Check this links

What is Link Tables? What is the use?

learnallbi.com/link-table-in-qlikview/

qliktips.com/2011/05/rules-for-creating-keylink-table-in.html

tdan.com/view-articles/5172/

Regards,

jagan.

Re: Key in qlikview

senpradip007 — Mon, 19 Jan 2015 06:35:32 GMT

Go through http://community.qlik.com/message/688811#688811 link.

Re: Key in qlikview

jagan — Mon, 19 Jan 2015 06:38:05 GMT

Hi,

Check this link also

http://community.qlik.com/message/569280#569280

Regards,

Jagan.

Re: Key in qlikview

Mon, 19 Jan 2015 06:51:25 GMT

HI Rgv,

Here you go...

Re: Key in qlikview

vikasmahajan — Mon, 19 Jan 2015 07:08:23 GMT

PFA detail Document and Also refer http://community.qlik.com/message/487650#487650

HTH

Vikas

Re: Key in qlikview

Mon, 19 Jan 2015 07:29:51 GMT

key is nothing a way to connect tables in qlikview by same name,Link table is the process to remove synthetic keys and developing a good data model in Qlikview(Star Schema)

Lets suppose you have more than 3-4 tables with different Date field

Sales:

load Id,

SalesDate,

Country

from SalesTab;

Order:

Load OrderId,

OrderDate,

Product

from OrderTab;

Purchase:

Load ProductName,

InvoiceNo,

InvoiceDate

From PurchaseTab;

Here we have Three date field SalesDate,OrderDate and InvoiceDate,but we need only single date field to map all the dates for that we need a Link table with unique Key,suppose we dont have unique field value none of our table,for that we have to create composite key..

Like Below

Link Table:

Load Id&'-'& SalesDate as Key

SalesDate as Date

Resident Sales

concatenate

Load OrderId &'-'& OrderDate as Key1

OrderDate as Date

Resident Order;

concatenate

Load InvoiceNo &'-'& PurchaseDate as Key2

InvoiceDate as Date

Resident Purchase;

then now You get a star flake Data model with Link Table.

Re: Key in qlikview

Anonymous — Mon, 19 Jan 2015 08:41:17 GMT

Thank you for ur explaination and your precious time

Thanks