Remove the blank values from a chart

[Anonymous]

Hi,

I have a chart that will display the products (Dimension) by the count of the IDs (Expression)

But I am getting the products with blank values.

How can I create a dashboard that will exclude the null blank values, I have tried the following:

- Dimension: ='=Product<>'' ''' - Tried with single and double quotes.

- Expression: =Count({< Product = {"<> "" "}>} AutoID) - Tried with single and double quotes

Both syntaxes are correct, but the dashboard doesn't display any data.

Any idea?

[jcs_2015]

"-" is the default null in Qlik for an Expression.  That can be changed per below.  The scripting above was to "display" a null Dimension.

[Anonymous]

Thank you for the update Jim, I think that now I can change the character there and then set another value to exclude records.

Thank you all for your help.

[jcs_2015]

You're welcome!