Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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"



Labels (1)
3 Replies
Partner - Specialist
Partner - Specialist


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.

Partner - Creator
Partner - Creator

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.

Specialist II
Specialist II

@KirstenKa  You can use the Set Analysis to resolve the issue

Count({<Filed -={'N/A'}>}Tickets)

This should resolve your issue.