Re: Define keys in table - Qlik Community

Anonymous · ‎2014-02-04

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

vikasmahajan · ‎2014-02-04

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

NO

W0

ID

CODE

GOOD LUCK

VIKAS

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2014-02-05

Hi,

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

Regards
Stefan

MK_QSL · ‎2014-02-05

You can load as below..

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