Bar chart: what to do if there are data for empty values in dimension

[#1]

Hi Everyone,

I have an incomplete dataset whereby I have sales by salesman but then I have sales not done by any of my recorded salesmen.

For example,
Mr Smith has £3000.00

Mr Jones has £5004.50

Mr Thomas has £9000.21

Mr Taylor has £203.99

then empty value has £9000000.32

How would in a bar chart I be able to ignore the bar chart representing the empty value?

Thank you

[MK_QSL · Accepted solution]

Go to your Script and instead of salesman, write below expression

If(Len(Trim(salesman))=0 or IsNull(salesman), Null(), salesman) as salesman,

Now

Go to dimension tab of your Bar Chart

and tick Suppress when value is NULL

[#3]

Thank you.

I tried out the isnull statement but that didn't work, but the length of the trim worked