topic Re: Apply map coming in as zero in QlikView

Apply map coming in as zero

Wed, 30 Mar 2016 13:22:23 GMT

I have 8 tables and 4 of them need fields from other tables, sometimes 1 table pulls fields from 2 different tables.

I set up mapping tables at the end of my script:

[ML_table 3 field 1]:

Mapping Load

[primarykey],

SUM([field) as [field1]

Resident [table that the field is coming from]

Group by [pirimarykey];

on the table that I need to pull this field, I put applymaps at the end of my load script:

Applymap ('ML_table 3 field 1',[primarykey],'N/A') as [mappingloadfield],

in a preceding load to that table, I use those fields in calculations.

I am getting '0's' in all of the columns. I have multiple applymaps in my loads and multiple mapping tables.

Could someone assist?

Thanks!!

Re: Apply map coming in as zero

sunny_talwar — Wed, 30 Mar 2016 15:02:26 GMT

I don't see a reason for a fail here. Can you share the complete script?

Re: Apply map coming in as zero

swuehl — Wed, 30 Mar 2016 15:28:44 GMT

I think there are some small typos in your code, but I assume they are just copy and paste errors.

I set up mapping tables at the end of my script:

[ML_table 3 field 1]:

Mapping Load

[primarykey],

SUM([field) as [field1]

Resident [table that the field is coming from]

Group by [pirimarykey];

on the table that I need to pull this field, I put applymaps at the end of my load script:

Applymap ('ML_table 3 field 1',[primarykey],'N/A') as [mappingloadfield],

in a preceding load to that table, I use those fields in calculations.

I am getting '0's' in all of the columns. I have multiple applymaps in my loads and multiple mapping tables.

You stated: "I set up mapping tables at the end of my script:"

Mapping tables need to be loaded before they are actually used (e.g. by using ApplyMap() ). Note there will be no script error if the mapping table does not exist.

Other than that, check the results of your mappings before doing the calculations.