Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
"-" is the default null in Qlik for an Expression. That can be changed per below. The scripting above was to "display" a null Dimension.
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.
You're welcome!