Remove N/A from graph

[KirstenKa]

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"

[julian_rodriguez]

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.

[whiteymcaces]

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.

[sidhiq91]

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

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

This should resolve your issue.