topic Re: ApplyMap function in QlikView

ApplyMap function

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

please let me know the error in below script

Score :mapping LOAD * INLINE [

Name, Gender

A, M

B, F];

Gender: load *, ApplyMap('Score',Gender,'NA') as x

inline [Name,Score

A,20

b,50] where x='M';

Re: ApplyMap function

hector_munoz — Sun, 30 Apr 2017 12:21:05 GMT

Hi Singh,

Try:

Score:

mapping LOAD * INLINE [

Name, Gender

A, M

B, F];

Gender:

load *

where x ='M';

load *,

ApplyMap('Score',Name,'NA') as x;

LOAD * inline

[Name,Score

A,20

b,50];

Take into account that QlikView is case sensitive... Hope it serves!

Regards,
H

Re: ApplyMap function

MK_QSL — Sun, 30 Apr 2017 20:15:54 GMT

Instead of Gender in ApplyMap, you have to use field which is similar to the 1st Field of Mapping Load table.

So here, you have to use Name

Re: ApplyMap function

shiveshsingh — Mon, 01 May 2017 06:45:21 GMT

plz confirm one thing, how can you define the same x as variable and as field name

load *

where x ='M';

load *,

ApplyMap('Score',Name,'NA') as x;

Re: ApplyMap function

hector_munoz — Mon, 01 May 2017 07:02:45 GMT

Hi Singh,

Here you are making nested LOAD sentences starting in the bottom one until the top one, so you are playing with the fields you are creating:

Gender:

load * // 3rd level: we have all the previous fields ('x', 'Name' and 'Score') but we filter by 'x' field

where x ='M';

load *,

ApplyMap('Score',Name,'NA') as x; // 2nd level: We add 'x' field to previous 'Name' and 'Score'

LOAD * inline // 1st level: 'Name' and 'Score' fields

[Name,Score

A,20

b,50];

Hope it is useful!

Regards,

Re: ApplyMap function

shiveshsingh — Mon, 01 May 2017 07:52:16 GMT

Hi Hector

Could you please let me know what is the exact error in below statement?

Score :mapping LOAD * INLINE [

Name, Gender

A, M

B, F];

Gender: load *, ApplyMap('Score',Name,'NA') as x

inline [Name,Score

A,20

B,50] where x='M';

Re: ApplyMap function

hector_munoz — Mon, 01 May 2017 08:40:00 GMT

HI,

The problem is in 'Gender' table and in its nested loads. The sentences of 'Gender' table should be:

Gender:

load *

where x='M';

load *,

ApplyMap('Score',Name,'NA') as x;

LOAD * inline

[Name,Score

A,20

B,50];

1st LOAD:

LOAD * inline

[Name,Score

A,20

B,50];

Creation of Gender table from an inline table with 'Name' and 'Score' fields.

2nd LOAD:

load *,

ApplyMap('Score',Name,'NA') as x;

B,50];

Creation of 'x' field from an ApplyMap.

3rd LOAD:

load *

where x='M';

Filtering records with 'x'= "M". This step has to be in this LOAD as in the preceding one we created X field.

Jope it is useful!

Regards,