purgechar, if not equal, not wildmatch? Which to use

[bobbydave]

Rate
BE-2014
0.11
AT-2016
UK-2016
1.11
1.21

I don't want to see BE-2014 or UK-2016 there are plenty more so I don't want to explicitly say if Rate <> AT....

Is there a way of say if(Rate <> ??-????, Rate)

I only want the Rate which would be something like 1.11 or 1 or 1.16

[tresesco]

Set system variable ('.' as decimal sepeartor) in the  script like:

SET DecimalSep='.';

And then you can simply use IsNum() like:

Load

          Rate

From <> where IsNum(Rate);

[PrashantSangle]

or

where len(KeepChar(CURRENT,'-'))=0;

Regards

[bobbydave]

I am using an ApplyMap to get the values of Rate in my load script.

ApplyMap('MapCountryToEuro', Country & '-' &  [Snapshot Year])  as Rate,

[qlikview979]

Hi Try this

I am getting this like 0.11,1.11,1.21

T1:

load * Inline [

Rate

BE-2014

0.11

AT-2016

UK-2016

1.11

1.21

];

NoConcatenate

T2:

load

Rate

Resident T1 Where IsNum(Rate);

DROP table T1;

[qlikview979]

Hi Bro, Please check

Your code is give output this  BE-2014,AT-2016,UK-2016

But he want  like this 0.11,1.11,1.21

Regards

[bobbydave]

No, my output is

BE-2014

0.11

AT-2016

UK-2016

1.11

1.21

I don't want it to look like that. I want it only to show 0.11, 1.11, 1.21

I could also use an expression if I couldn't do it in the load script as I have the values ... I just need to filter them to remove the ??-???? values

[marcus_malinow]

Sounds like the following may help:

ApplyMap('MapCountryToEuro', Country & '-' &  [Snapshot Year], Null())  as Rate,

[tresesco · Accepted solution]

Hello bobbydave‌,

You can use the same applymap in the where clause like:

Load

          *

From <> where IsNum(ApplyMap('MapCountryToEuro', Country &'-'&[Snapshot Year]));

[Anil_Babu_Samineni]

Bobby,

As you are expecting Mahesh gave, Right?

If still issue please post a sample qlikview application which demonstrates the problem