Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
stefan_fischer
Contributor II
Contributor II

Define keys in table

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

3 Replies
vikasmahajan

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

NOW0IDCODE

GOOD LUCK

VIKAS

stefan_fischer
Contributor II
Contributor II
Author

Hi,

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

Regards
Stefan

MK_QSL
MVP
MVP

You can load as below..

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