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

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

Mon, 08 Sep 2014 12:49:07 GMT

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 — Mon, 08 Sep 2014 12:57:09 GMT

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

Mon, 08 Sep 2014 14:21:06 GMT

Thank you.

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