Discussion Board for collaboration on QlikView Scripting.
When I am concatenating 20 with one column it gave me wrong result. Below is the script
'20' & Right([Fiscal Year],2) AS FY ,
where Fiscal Year is FY10, FY11,FY12,FY13
The desired result is 2010,2011,2012,2013
Result which I am Getting 20,2010,2011,2012,2013
I want to remove that unwanted 20
Thanks in advance
Go to Solution.
What is the Fiscal Year value for the record you get 20 in FY (just select 20 in FY and look at the other field)?
I assume it's NULL.
You can check for NULL like
if(len(trim([Fiscal Year])), '20' & Right([Fiscal Year],2) ) AS FY ,
It seems you have one (or more) record with NULL into [Fiscal Year] field
Check out the Solution given in the below file
Nothing Changes required.
hope it helps you.
Thanks a lot swehl, it worked