topic Re. :Re: HOW TO DO 2 MAPPING FUNCTIONS TOGETHER ??? in QlikView

HOW TO DO 2 MAPPING FUNCTIONS TOGETHER ???

Thu, 07 Apr 2011 07:34:17 GMT

HELLO FRIENDS!!!

This is a problem i met when i was doing some mapping functions.

I have added in the qlikview file for this problem, please do take a look and post your solutions!

Thank You!!! =D

Thu, 07 Apr 2011 07:44:11 GMT

Hello

Using if() didnt help? like

if(Quantity>'0', Available, Unavailable) as qty

Thu, 07 Apr 2011 07:49:30 GMT

Hi Muncho!

I tried using if functions, but i tried using inside the mapping, but i guess it didn't work.

Please feel free to have a look at my sample, i don't really get what you mean though.

Thanks! 😄

Thu, 07 Apr 2011 08:03:56 GMT

Hello

I'm also didn't get it. You are trying to make field and fill it if Quantity =0 then Unavailable else Available right?

btw im new in QV >.< Sorry if i ruining your time.

vincent_ardiet — Thu, 07 Apr 2011 09:20:30 GMT

Hi,

Muncho is right, you can use a IF, like:

IF(QUANTITY=0,'UNAVAILABLE','AVAILABLE') as QTY_Status

But if you want to use a mapping you can try with the default value :

mapConditions:

MAPPING LOAD * INLINE

[

Cond, Descr

CANNOT FIND, CANNOT FIND

*, MISSING VALUE

];

mapQTYConditions:

MAPPING LOAD * INLINE

[

Cond, Descr

0, UNAVAILABLE

];

Data:

load *,

applymap('mapConditions', PRICE,) as Status,

applymap('mapQTYConditions', QUANTITY,'AVAILABLE') as QTYStatus;

Regards,

Vincent