topic Re: select only numeric values in QlikView

select only numeric values

ecabanas — Mon, 16 Mar 2015 12:38:43 GMT

Hi,

I have this map in load script:

INVENTTRANS:

LOAD *,

ApplyMap('WAC_MAP',LINK_WAC) AS WAC

from $(VStore)INVENTTRANS_WAC.qvd (qvd);

I would like to applymap only if the field is numeric is it possible?

Re: select only numeric values

rubenmarin — Mon, 16 Mar 2015 12:45:12 GMT

Hi Eduard, you can use the IsNum() function, ie:

If(IsNum(LINK_WAC, ApplyMap('WAC_MAP',LINK_WAC) [,InstructionsIfNotIsNumeric]) as WAC

Re: select only numeric values

Mon, 16 Mar 2015 12:55:14 GMT

Hi Eduard,

the other option you have is to ensure only numerical values are present in your applymap itself, then that is only what will be mapped when you use it

hope that helps

Joe

Re: select only numeric values

sunny_talwar — Mon, 16 Mar 2015 12:55:57 GMT

If your mapping load table doesn't have a mapping available for certain LINK_WAC the default value will be LINK_WAC unless you specify another default value. Take a look at the image below:

HTH

Best,

Re: select only numeric values

ecabanas — Mon, 16 Mar 2015 13:09:07 GMT

Hi Ruben,

I did but it returns this error:

Error in expression:

IsNum takes 1 parameter

INVENTTRANS:

LOAD *,

If(IsNum(ApplyMap('WAC_MAP',LINK_WAC), ApplyMap('WAC_MAP',LINK_WAC) ,TARIFAREFERENCIAL) as WAC

from E:\Data BI\Documents\QVD\INVENTTRANS_WAC.qvd (qvd)

Many thank's

Re: select only numeric values

sunny_talwar — Mon, 16 Mar 2015 13:15:30 GMT

You might need another ) after your first ApplyMap like this:

If(IsNum(ApplyMap('WAC_MAP',LINK_WAC)), ApplyMap('WAC_MAP',LINK_WAC) ,TARIFAREFERENCIAL) as WAC

HTH

Best,

Re: select only numeric values

ecabanas — Mon, 16 Mar 2015 13:26:36 GMT

Many many thank's Ruben