topic Re: Isnull function in QlikView

Isnull function

Kushal_Chawda — Mon, 22 Jul 2013 05:19:42 GMT

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

Re: Isnull function

luciancotea — Mon, 22 Jul 2013 05:27:03 GMT

See rangesum ()

Re: Isnull function

Mon, 22 Jul 2013 05:31:22 GMT

try this

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

or this

if(Sales= ' ',0,Sales)

or try this in script--

Re: Isnull function

priyav24 — Mon, 22 Jul 2013 05:50:10 GMT

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.