topic Re: converting null value-failure in QlikView

converting null value-failure

manoranjan_d — Tue, 03 Oct 2017 11:27:53 GMT

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?

sunny_talwar — Tue, 03 Oct 2017 11:33:32 GMT

May be try this

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

Or — Tue, 03 Oct 2017 11:36:22 GMT

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 — Tue, 03 Oct 2017 11:42:21 GMT

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