Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

converting null value-failure

Hi all,

In my backend data base i have null value example below

Backend Data:
Low_USD

NULL

55.49

0.00

100.45

Now in my script i have given 3 types of try but its not working  to covert this null value

if(Low_USD=Null() or Low_USD='NULL',0.00,Low_USD) AS [Low_USD]

as per condition it shd show 0.00 but its showing 0 only

i also tested with character also

if(Low_USD=Null() or Low_USD='NULL','A',Low_USD) AS [Low_USD],

again its showing as 0 only not the A

even i tried the thrid one also

if(isnull(Low_USD) or Low_USD='NULL' or Low_USD=' ' ,'0.00',Low_USD) as [Low_USD]

its not showing the value as 0.00 its showing only 0 only

these are being tested in the list box value

le tme know how to cinvert this?

3 Replies
sunny_talwar

May be try this

If(Len(Trim(PurgeChar(Low_USD, Chr(160)))) = 0, '0.00', Low_USD) as Low_USD

Or
MVP
MVP

If(Isnull(Low_USD),'A',Low_USD)


Null = Null evaluates to false (null does not equal null).


If your column is numeric, you can also use Len(Low_USD) = 0. If it's text, an empty string would be a problem in that case.

pradosh_thakur
Master II
Master II

hi

try using fucntion isnull()

it returns -1 if value is null or else zero

so your expression would be

if(isnull(Low_USD) = -1 or upper(Low_USD)='NULL' or Low_USD=' ' ,'0.00',Low_USD) as [Low_USD]


check the format of the column in the number of the chart you are using.


regards

Pradosh

Learning never stops.