- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Remove N/A from graph
With this code I transformed the empt values in N/A
NullAsValue *;
Set NullValue = 'N/A';
However now I would like to remove the N/A in my graph, which can't be done by "unchecking the zero values"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To remove the 'N/A' values from your Qlik Sense graph, you can't simply uncheck zero values because 'N/A' is not considered a zero value; it's an actual string that you've set to represent null values. However, you can use a couple of methods to exclude 'N/A' from your visualizations.
One common method is to use set analysis within your chart expressions to ignore 'N/A' values. Here's a general example of how you might adjust a chart expression to exclude 'N/A':
Sum({<YourField-={'N/A'}>} Value)
In this expression, YourField
should be replaced with the actual field name that contains the 'N/A' values, and Value
should be replaced with the measure you are summing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Another option is to remove the rows of data that have null values. However, you need to ask yourself why you have null values in the first place. Is there dimension data missing? Have you associated un-associated data in the script? Many, many questions. More context will result in more specific answers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@KirstenKa You can use the Set Analysis to resolve the issue
Count({<Filed -={'N/A'}>}Tickets)
This should resolve your issue.