Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.