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?
PFA SAMPLE HOPE THIS HELPS YOU , YOU NEED TO CREATE LINK OF COMBINATIONS OF FOLLOWING FIELDS PLEASE REFER DEMO ATTACHED.
if i load datas, there are duplicate ID's. How can i prevent dublicate keys?
You can load as below..
Load Distinct ID..... from table...
Retrieving data ...