Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

gauravkhare
Contributor

Removing '-' from the output!

Dear al,

I have a simple query(though I' am not getting it right)...I have a table in which there are certain fields where in some cases their respective attributes are apparing as '-'  (hyphen)

Now in that way my count of policy is appearing more than it is in actual, as I' am writing count(distinct Pol_ID)

i have tried there various options like...suppress where the value is null etc etc.. but it's not working

kindly help out

3 Replies
Not applicable

Removing '-' from the output!

In Chart properties, the Presentation tab, Lower left corner there are two fields: NULL SYmbol and Missing Symbol. Clear out the - in there.

hth Jeroen

Not applicable

Re: Removing '-' from the output!

Is it possible for you to share the document?

Arun

gauravkhare
Contributor

Removing '-' from the output!

I m done with it...thanks