Do not have 'empty name' in the data but have 'empty' fields in the bar chart

[Anonymous]

Hi,

I am creating a bar chart using 'ProductName' showing belong. having the longest bar as '_' with out name

But when i check the data manager, I did not find any '_' (empty name here), showing below

any suggestion regarding possible reason and any solutions?

thank you!

[Anonymous]

This links to the other question I asked but did not get the answer.

how to create 'inner join' for the 2 data set | Qlik Community

I only use data manager to join the bubbles now.

I tried to use

inner join or Keep inner

function in data load editor according to the instruction from this forum. but those ways do not work still.

thank you so much.

[cazztfplease · Accepted solution]

First you may try to uncheck the 'Include null values' checkbox.

Occasionally, you may get values that do not appear as nulls but are 'empty'.  You may use this script in your chart dimension to have those values not shown:

= if (len(trim(ProductName))>0,ProductName)

This is a simple if/then statement that says, if the string length of the value for ProductName is anything over 0, show me ProductName.  So the rows that have no value should not be returned and therefore not shown in the chart.