topic how to replace the ( ) null value with 'N/A' in QlikView

how to replace the ( ) null value with 'N/A'

Wed, 30 Jul 2014 13:24:25 GMT

can anyone help me in writing the below expression correct

my issue i need to replace the N/A with ' ' from one them but now i need to show N/A when both the expressions have N/A how can I write it can anyone help me.

=if([Results]='N/A','',[Results]) &''&

if([HI RESULTS ]='N/A','',[HI RESULTS])

Re: how to replace the ( ) null value with 'N/A'

joshabbott — Wed, 30 Jul 2014 13:29:46 GMT

Just add the if for both = N/A before your script below, and make your script the 'else' piece

=if([Results] = 'N/A' and [HI RESULTS] = 'N/A', 'N/A',

if([Results]='N/A', '', [Results]) & '' & if([HI RESULTS] = 'N/A', '', [HI RESULTS]) )

Re: how to replace the ( ) null value with 'N/A'

avinashelite — Wed, 30 Jul 2014 13:29:57 GMT

Hi,

If you want to replace the null with N/A then use.

if(isnull(fieldname), 'N/A',filedname)

Re: how to replace the ( ) null value with 'N/A'

MK_QSL — Wed, 30 Jul 2014 13:30:46 GMT

=if([Results]='N/A' and [HI RESULTS ]='N/A','N/A',

if([Results]='N/A' and [HI RESULTS ]<>'N/A',Results,

if([Results]<>'N/A' and [HI RESULTS ]='N/A',[HI RESULTS])))

Re: how to replace the ( ) null value with 'N/A'

michael_maeuser — Wed, 30 Jul 2014 13:30:55 GMT

hi, I don´t understand exatly but do you need this?

=if([Results]='N/A' and [HI RESULTS ]='N/A','N/A',[Results])

maybe you can explain a bit more detailed?

thanks!

Michael

Re: how to replace the ( ) null value with 'N/A'

jjordaan — Wed, 30 Jul 2014 13:41:14 GMT

Hi Apache77,

What Avinash is telling is correct.

But of you user applymap you can use the 3th parameter of applymap to display a certain Value if the Value is nul.

Hope this helps.

Best regards