topic Re: Apply map issue in QlikView

Apply map issue

bharatkishore — Fri, 25 May 2018 08:34:35 GMT

Hi All, i have the below code:

Category:

LOAD (Modality) as Key,

Consumption

FROM

[..\\Period_Level1_1.qvd]

(qvd);

Final_Category:

Mapping

Load Key,

Consumption

Resident Category;

Drop table Category;

Overview:

LOAD (Modality) as Key

FROM

[..\sum.qvd]

(qvd) where match(Modality,'AMI','CT','MR','US','DXR','IXR');

Final_Overview:

LOAD Key,

IB,

ApplyMap('Final_Category',Key,'') as Consumption

Resident Overview;

DROP Table Overview;

After reloading my consumption value is becoming 4 times higher.

Can you please tell me where i am missing.

Thanks,

Bharat

shansundar — Fri, 25 May 2018 09:54:38 GMT

Script looks correct, please upload sample qvw file with data we can try and let you know.

Thanks,

Shan S

bharatkishore — Fri, 25 May 2018 10:12:13 GMT

Thanks SS.

Issue is in the data side.. figured it out.. If anything else is there will keep you posted.

Thanks again..