List of alphabets a numbers in a field together

[#1]

Hello

I have a list of of numbers in a field also 'N/A' how do i write a code segment to display N/A on my straight table rather than '-'

ex:

1 Fieldname;

2  234

3  457

4  507

5  'N/A'

6  731

.....

n   n

Thanks

[saumyashah90]

If you have this as text you will have proper output.

Can you tell what is your input table

[#3]

I got '-' (dash) in place of N/A in my straight table

[saumyashah90]

Mine worked properly

[Anonymous]

If you look on the  chart's Presentation tab you have the option to set what symbol is used for Null and missing values. This might enable you to fix this. Otherwise you might need to use the NullAsValue script functions to get the values you want to appear.

[saumyashah90]

If not,

Just  before loading the script use this

Set verbatim =1

[#7]

This isnt what i meant. I mean a mixture of both numeral and alphabet in a field

example

FIELD

23

33

76

90

11

N/A

23

389

33

[Anonymous]

QlikView shouldn't really care about data types. Just bring in all the values from your data source. Obviously, things like sorting and calculations will need special consideration but the data will be in there.

[Anonymous]

Hi,

It depends on field type.

if its numeric,values other than numeric like N/A is as good as null.

nulls should be treated separately.

please be more specific,so can help.

Regards

Neetha

[anbu1984 · Accepted solution]

If(IsNum(FIELD),Max(FIELD),'N/A')