Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello bobbydave,
You can use the same applymap in the where clause like:
Load
*
From <> where IsNum(ApplyMap('MapCountryToEuro', Country &'-'&[Snapshot Year]));
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);
or
where len(KeepChar(CURRENT,'-'))=0;
Regards
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
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;
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
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
Sounds like the following may help:
ApplyMap('MapCountryToEuro', Country & '-' & [Snapshot Year], Null()) as Rate,
Hello bobbydave,
You can use the same applymap in the where clause like:
Load
*
From <> where IsNum(ApplyMap('MapCountryToEuro', Country &'-'&[Snapshot Year]));
Bobby,
As you are expecting Mahesh gave, Right?
If still issue please post a sample qlikview application which demonstrates the problem