Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is part of my script I loaded into Qlikview:
SQL SELECT DESCRIPTION,
IDENTIFIER,
"PMID_H0",
"MS_STATUSID",
MID
FROM IKSDB.TBEQUIPMENT
Where ("MS_STATUSID" = '14');
SQL SELECT MSID,
MID,
STATUSID
FROM IQREVDB.TBMSTRATEGY
Where (STATUSID = '6');
SQL SELECT MSID,
TITLE,
"CP_TASK",
"CP_TASK_DESC",
"CP_TASK_FREQ",
"CP_TASK_FREQ_UNITID",
TASKTYPE,
"TASK_FREQ",
"TASK_FREQ_UNIT_ID" as "UNIT_ID"
FROM IQREVDB.TBMSTRATEGYTASKS;
SQL SELECT "UNIT_ID",
UNIT,
DESCRIPTION,
"DAYS_CONVERTED"
FROM IQREVDB.TBUNITS;
I want the tables to link the tables by MID, MSID, and "UNIT_ID". When I load this script, Qlikview automatically links MID, MSID, and DESCRIPTION. What do I need to do to accomplish this? I got the links I wanted when I commented-out one of the DESCRIPTIONS, but that takes away from my data...
rename one of your DESCRIPTION fields using AS
rename one of your DESCRIPTION fields using AS
Hi,
es Stefan said you will solve your issue by renaming the DESCRIPTION field using AS.
But besides that i would like to share with you a basic guideline about composite keys in QlikView, they generate synthetic keys that should be avoided.
I recommend you to read the following article:
Hope this helps.
Kind regards,