Get rid of hyphens in Pivot Table (Direct Discovery)

[#1]

Hi Guys,

How do you get rid of - (Hyphen) in the Pivot Table in QLik Sense?

I am using Direct Discovery

DB- Jethro

Thanks,

Bhanu

[hemhund2016]

Hi ,

It is the null value. You can write expression like below.

If(isnull(Expression),'NA',Expression)

Thanks,

Hemanth.

[#3]

Hi Hemanth,

I tried that it is not working.

Tried alt(Expression,'NA') too .. this also didnt work.

Was wondering if the reason is because I'm using Direct Discovery

Thanks,

Bhanu