empty bar in bar chart

[adiarnon]

hi,

i have a bare chart with two dimensions with group style

i limited the second dimension (LOB) to five and i get the result i want

BUT i have the empty bars (because the LOB not exist in quarters).

How can i hide those bars?

[Chanty4u]

did you check the option suppress null values in dimension[each] tab and presentation tab?

[adiarnon]

yes

its not working

[uacg0009]

Hi adi,

could you please upload a sample? so I can try to make it happen in your situation.

Thanks.

Aiolos

[adiarnon]

i cant upload file to the web in my company

[kevinalvino]

Hi Adi,

You can achieve it by :

In Expression tab, Look for the formula used to calculate LOB. Set the Conditional to = IF(NOT IsNULL(Dimension for LOB)).

Depends on the formula, i recommend you to create multiple expression with set analysis per dimension , so it easier to manage. If you do this way , then in Conditional field, you can write : IF ( *Formula used to calculate LOB* <>0 ) or you can use NOT IsNULL again , if you not handling Null as 0 Value.

Hope it helps,

Best Regards,

Kevin