topic empty bar in bar chart in QlikView

empty bar in bar chart

adiarnon — Mon, 16 Apr 2018 05:52:28 GMT

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?

Re: empty bar in bar chart

Chanty4u — Mon, 16 Apr 2018 05:55:37 GMT

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

Re: empty bar in bar chart

adiarnon — Mon, 16 Apr 2018 05:59:36 GMT

yes

its not working

Re: empty bar in bar chart

uacg0009 — Mon, 16 Apr 2018 06:33:25 GMT

Hi adi,

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

Thanks.

Aiolos

Re: empty bar in bar chart

adiarnon — Mon, 16 Apr 2018 06:40:44 GMT

i cant upload file to the web in my company

Re: empty bar in bar chart

kevinalvino — Mon, 16 Apr 2018 07:32:07 GMT

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