Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bharatkishore
Contributor III

Apply map issue

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

     IB

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

2 Replies
Partner
Partner

Re: Apply map issue

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

Thanks,

Shan S

bharatkishore
Contributor III

Re: Apply map issue

Thanks SS.

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

Thanks again..