Unable to replace Null values with 0

[#1]

Hi,

I am unable to replace null values  '-'  with 0.

I am using if(IsNull((Count(iD))),0,(Count(iD)))

Attaching my app for better understanding.

Regards,

Vinayak

[zhadrakas]

you can try

if(len(Count(iD))>0, Count(iD),0)

[#3]

HI Tim,

Its not working for me.

Thanks,
Vinayak

[zhadrakas]

dont know if this is possible in qlik sense.

In QlikView there was an Option in Presentation of an object to Display null values as..

[tomasz_tru]

You can not do much about NULLs that are being created in calculations. And it's logical that Qlik do not allow you to set zero where the value is unknown. You can modify data model to make sure every combination of Period/City has it's ovn value even if it is 0.

Tomasz

[#6]

Hi TIm,

We cannot do this in QlikSense

Regards,

VInayak

[#7]

Hi Thomasz.,

Thanks for taking out time for this discussion,

As I am very new to this tool if you could elaborate on your previous comment as I dont know much in Qlik Sense.

Regards,
Vinayak

[pathiqvd]

Hi,

Try with "alt" function,

like

alt(ID,0)

it will replace with 0 or whatever u give

Regards,

[#9]

HI laxmipathi,

Sir its not working for me.

Regards,
Vinayak

[qv_testing]

HI,

i.e not NULL data, you don't have data.

QlikView side we have option, Missing Symbol..

I think we don't have any option Qlik sense side..