Isnull function

[Kushal_Chawda]

Dear All,

In SQL serevr , I can write the query as isnull(sum(Sales) ,0.00).. means if there is null values encounters, it will display 0.00.

I am looking for fuction which is similar to above example in qlikview.

I can write the expression as : if(isnull(sum(sales),0,sum(sales)) but my actual expression is very huge. so I cant use if condition.. so i am looking for simple one condition which will give me 0 wherever values is null..

Is there any function in qlikview?

Regards,

kush

[luciancotea · Accepted solution]

See rangesum ()

[#3]

try this

if(sum(Sales) = ' ',0,sum(Sales))

or this

if(Sales= ' ',0,Sales)

or try this in script--

[priyav24]

Hi

If you are using straight table,

Go to Properties->Presentation->select the expression

There will be an option called Null Symbol below where you can modify in a format you want.

By default for Null symbol it is"-",you can modify it as 0.00

Please find the attachment for your reference.