Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Unable to replace null values with NA

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

7 Replies
mayuringale25
Partner
Partner

Hi @NavinReddy 

 

mayuringale25_0-1601533893673.png

 

Please find attatched qvf 

Thanks and Regards
Mayur Ingale
NavinReddy
Creator II
Creator II
Author

@mayuringale25  Thanks for your reply 

im unable to open qlikview application, please suggest me

 

mayuringale25
Partner
Partner

hi @NavinReddy 

The qvf is qlik sense file.

Thanks and Regards
Mayur Ingale
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

Thanks & Regards,
Mayil Vahanan R
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Janaszek
Contributor II
Contributor II


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

1.png

Janaszek
Contributor II
Contributor II

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