- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get rid of the labelled '-' data in graphs?
Hi,
I am using Qlik 9.00 in windows. In any graph, whenever I do a selection, there's data labelled as "-" and that apparently represents the accumulated data as if the selection wasn't present, that is, "-" represents the sum of all the data. I'd like to get rid of this data, because usually, this represents a huge ammount in comparison with the select data and makes the graphs rather ugly.
How can I achieve this?
thanks.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Manuel,
Go to the object properties, Dimensions tab, and check "Supress when the vale is null".
Marc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Although I am using a different version to you I have always found that the '-' means there is data that does not have the dimension you are graphing, i.e. if you are graphing number of sites by city if you have a bar etc with '-' it would mean you have some records that have no city data.
Hope that elped and didn;t just confuse your situation more.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ok, even if that's the correct interpretation, how can I get rid of that ?
thanks for answering.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Manuel,
Go to the object properties, Dimensions tab, and check "Supress when the vale is null".
Marc.