topic Re: Nested ApplyMap? in QlikView

Nested ApplyMap?

kashjaniqlik — Tue, 16 Dec 2014 14:58:58 GMT

Hello

With Applymap, if the mappings are not found, is there any way we could then get it to look at a different list. We have a column in our qlikview table which maps to a column in excel file and gets the value from the second colum in excel to show in Qlikview.

If for someone reason, the mapping is not found, could we get Qlikview to look at a different list? This will mean the column in the data model will show the value either from the first or second list.

Sorry if it's confusing but I couldn't explain it much easier.

Thanks

Re: Nested ApplyMap?

yduval75 — Tue, 16 Dec 2014 15:02:43 GMT

Yes, with applymap function, you can write a third parameter to specify the value if the applymap doesn't meet value.

applymap('mapname', expr [ , defaultexpr ] )

For example, tou can specify another applymap as third parameter inside the applymap function

Re: Nested ApplyMap?

MK_QSL — Tue, 16 Dec 2014 15:05:34 GMT

Like this?

Cust1:

Mapping Load * Inline

[

Cust, Country

A, UK

B, Germany

C, France

H, Poland

];

Cust2:

Mapping Load * Inline

[

CustID, Country

D, Spain

E, Ukraine

I, Hungary

];

Load

ApplyMap('Cust1',Customer, ApplyMap('Cust2',Customer,'Unknown')) as Country

Inline

[

Customer, Sales

A, 100

B, 120

C, 80

D, 400

E, 500

F, 125

];

Re: Nested ApplyMap?

kashjaniqlik — Tue, 16 Dec 2014 15:32:01 GMT

Thanks Yoann although please look at my response to Manish's solution.

Re: Nested ApplyMap?

kashjaniqlik — Tue, 16 Dec 2014 15:35:57 GMT

Thanks Manish. Your solution is close to what I'd like to get to, although in second applymap I have a different field to map to. If I take your example, my first applymap is mapping on Customer. If no customers are found, my second applymap is mapping on a different field within the qlikview table with similar values (Country)

Re: Nested ApplyMap?

MK_QSL — Tue, 16 Dec 2014 15:38:49 GMT

Cust1:

Mapping Load * Inline

[

Cust, Country

A, UK

B, Germany

C, France

H, Poland

];

Cust2:

Mapping Load * Inline

[

CustID, Country

DD, Spain

EE, Ukraine

II, Hungary

];

Load

ApplyMap('Cust1',Customer, ApplyMap('Cust2',ID,'Unknown')) as Country

Inline

[

Customer, Sales, ID

A, 100, AA

B, 120, BB

C, 80, CC

D, 400, DD

E, 500, EE

F, 125, FF

];

Re: Nested ApplyMap?

yduval75 — Tue, 16 Dec 2014 15:39:35 GMT

I think It will work.

ApplyMap('Cust1',Customer, ApplyMap('Cust2',Country,'Unknown')) as Country

Re: Nested ApplyMap?

kashjaniqlik — Tue, 16 Dec 2014 16:20:11 GMT

Thanks Yoann very much. Yes it works.

Re: Nested ApplyMap?

kashjaniqlik — Tue, 16 Dec 2014 16:20:32 GMT

Thanks Manish for your help. Your both solution works. Great.