
Creator II
2011-06-21
09:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- new_to_qlikview
2,986 Views
3 Replies

Not applicable
2011-06-21
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
349 Views

Not applicable
2011-06-21
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is it possible for you to share the document?
Arun
349 Views

Creator II
2011-06-22
01:51 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I m done with it...thanks
349 Views
