Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravkhare
Creator II
Creator II

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

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

Is it possible for you to share the document?

Arun

gauravkhare
Creator II
Creator II
Author

I m done with it...thanks