topic Re: applymap in QlikView

applymap

Wed, 03 Apr 2013 06:41:55 GMT

Hi,

I'm trying to use a map to add a description

here is my map:

MapTest:

MAPPING LOAD

Num(@1),

FROM

$(CHEMIN)Data_to_Load\SIGNA_*.TXT

(txt, codepage is 1252, no labels, delimiter is ',', msq);

here is the applymap:

ApplyMap('MapTest',Num(Field1)) AS description

The issue is when there are no correspondence, it doesn't put the value from Field1 else it puts correctly the value of the map.

thanks

Re: applymap

kaushiknsolanki — Wed, 03 Apr 2013 06:48:13 GMT

Hi,

Do you mean when there is no mapping apply, it shows nothing?

If yes then this is correct, when you say system to map something but if you dont specify what to map with what, it will not map. It will only map where it maches the field value.

Kindly give one example.

Regards,

Kaushik Solanki

Re: applymap

er_mohit — Wed, 03 Apr 2013 07:01:48 GMT

ApplyMap('MapTest',[Num(@1)]) AS description

hope it helps

Re: applymap

Anonymous — Wed, 03 Apr 2013 10:03:47 GMT

I have just started using ApplyMap() (I am a beginner) and I supply a default when no value is present:

ApplyMap('MarketMap', ValueToTest, 'Others') As Market,

This defaults 'Others' when no corresponding value is found.

Ian

Re: applymap

Wed, 03 Apr 2013 12:03:25 GMT

thanks for your help

now it works correctly with your solutions.