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
Set system variable ('.' as decimal sepeartor) in the script like:
And then you can simply use IsNum() like:
From <> where IsNum(Rate);
I am using an ApplyMap to get the values of Rate in my load script.
ApplyMap('MapCountryToEuro', Country & '-' & [Snapshot Year]) as Rate,
Hi Try this
I am getting this like 0.11,1.11,1.21
load * Inline [
Resident T1 Where IsNum(Rate);
DROP table T1;
No, my output is
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
As you are expecting Mahesh gave, Right?
If still issue please post a sample qlikview application which demonstrates the problem