topic Re: Define keys in table in QlikView

Define keys in table

Anonymous — Tue, 04 Feb 2014 12:07:29 GMT

Hi,

i have three tables in an excel sheet and I want to link this tables in QlikView. The key is an ID in all tables. How can I link up these keys. How can I count the ID’s in an formula?

Regards
Stefan

Re: Define keys in table

vikasmahajan — Tue, 04 Feb 2014 12:15:58 GMT

PFA SAMPLE HOPE THIS HELPS YOU , YOU NEED TO CREATE LINK OF COMBINATIONS OF FOLLOWING FIELDS PLEASE REFER DEMO ATTACHED.

CODE

GOOD LUCK

VIKAS

Re: Define keys in table

Anonymous — Wed, 05 Feb 2014 08:08:54 GMT

Hi,

if i load datas, there are duplicate ID's. How can i prevent dublicate keys?

Regards
Stefan

Re: Define keys in table

MK_QSL — Wed, 05 Feb 2014 08:12:22 GMT

You can load as below..

Load Distinct ID..... from table...