HOW TO DO 2 MAPPING FUNCTIONS TOGETHER ???

[#1]

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

[#2]

Hello

Using if() didnt help? like

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

[#3]

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! 😄

[#4]

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]

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