Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Get rid of hyphens in Pivot Table (Direct Discovery)

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

2 Replies
hemhund2016
Contributor

Re: Get rid of hyphens in Pivot Table (Direct Discovery)

Hi ,

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

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

Thanks,

Hemanth.

Not applicable

Re: Get rid of hyphens in Pivot Table (Direct Discovery)

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