topic Re: Assistance required in qlikview script in QlikView

Assistance required in qlikview script

ashmitp869 — Fri, 30 Apr 2021 04:35:57 GMT

Hi there,

I am trying to achieve the below join in the qlikview data model.

When I join the new table GP , It became with table name prefix -

Please kindly assist me in the qlikview script.

Here is the script below :

ED_AP_PAT_TMP:
NoConcatenate
LOAD DISTINCT
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident ED;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], if([AP._discharge_flag] = 1, NULL(), 'Yes') as [Exclude Discharged Stay]
Resident AP;

ED_AP_PAT:
NoConcatenate
LOAD DISTINCT *
RESIDENT ED_AP_PAT_TMP;

DROP TABLE ED_AP_PAT_TMP;

ED_AP_PAT_TMP1:
Concatenate (ED_AP_PAT)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident GP;

DROP FIELD [Person Area Uid],[Facility Identifier] FROM ED;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM AP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM GP;

regards

Re: Assistance required in qlikview script

Lisa_P — Fri, 30 Apr 2021 04:44:09 GMT

Are you using Qualify in your script ?

Re: Assistance required in qlikview script

ashmitp869 — Fri, 30 Apr 2021 04:52:39 GMT

No, I remove the Qualify .

and Put Unqualify * but not working

Re: Assistance required in qlikview script

Lisa_P — Sun, 02 May 2021 22:42:12 GMT

can you show more of your script to let us see what's happening

Re: Assistance required in qlikview script

ashmitp869 — Mon, 03 May 2021 00:25:16 GMT

ED_AP_PAT_TMP:
NoConcatenate
LOAD DISTINCT
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident ED;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], if([AP._discharge_flag] = 1, NULL(), 'Yes') as [Exclude Discharged Stay]
Resident AP;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], 'Y' as [Exclude Discharged Stay]
Resident GP;

UNQUALIFY *;

ED_AP_PAT:
NoConcatenate
LOAD DISTINCT *
RESIDENT ED_AP_PAT_TMP;

DROP TABLE ED_AP_PAT_TMP;

DROP FIELD [Person Area Uid],[Facility Identifier] FROM ED;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM AP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM GP;

Re: Assistance required in qlikview script

Lisa_P — Mon, 03 May 2021 00:49:15 GMT

There must be a Qualify earlier in the script that is qualifying each [Exclude Discharged Stay]

Re: Assistance required in qlikview script

ashmitp869 — Mon, 03 May 2021 00:52:38 GMT

Hi Lisa ,

the field [Exclude Discharged Stay] is created on this tab for the first time by this script , so I ne ver Qualify [Exclude Discharged Stay] before the script.

Re: Assistance required in qlikview script

Lisa_P — Mon, 03 May 2021 00:54:18 GMT

But if you did Qualify *; somewhere earlier in your script, it will apply until your Unqualify *;