Unable to replace null values with NA

[NavinReddy]

Hello All,

im unable to replace null values with NA, i have tried with multiple function its not working for me.

Kindly could someone help me.

if(Len(Trim(Value))=0 or Isnull(Value),'NA',

if(Type= 'MON',Num(MaxString({<MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}>}Value),'$###,###.00')&'',
if(Type= 'PCT',Num(MaxString({<MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}>}Value)*100,'##.00%'&' ')&'',
if(Type= 'QTY',Num(MaxString({<MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}>}Value),',###,###.')))))

Thanks & Regards,

NR

[mayuringale25]

Hi @NavinReddy 

Please find attatched qvf 

[NavinReddy]

@mayuringale25  Thanks for your reply 

im unable to open qlikview application, please suggest me

[mayuringale25]

hi @NavinReddy 

The qvf is qlik sense file.

[MayilVahanan]

Hi Navin,

Convert the null value with 'NA' in script. and use in front end.

if(Len(Trim(Value))=0 or Isnull(Value),'NA', Value) as Value

Hope it helps

[Brett_Bleess]

Here are some links that may be of use:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Value...

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279

https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988

There is also ability to change directly in some chart types, see Help below for example:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_St...

Regards,
Brett

[Janaszek]

can you help me in the pivot table.
I want to hide the rows where column 2 = 0.
how to do it quickly?

[Janaszek]

I want to hide the rows where column 2 > 0.