topic HELP! need to hide bars with zero value (complicated) in QlikView

HELP! need to hide bars with zero value (complicated)

Fri, 20 Nov 2020 18:02:30 GMT

Hi everyone! I am relatively new to qlikview and have a question about hiding the "bars" and axis labels which have zero/null value...

no other answers have worked because my data is set up in an unique way.

I need to hide the budget and forecast from 12h2 through 13h2 so that there is no empty space in my graph.

I have the dimensions HALF (13H1 ect) and the dimension SOURCE (BUDGET FORECAST ACTUAL)

I have the dimensions Commission $ Amount (the darker shade) and MBO $ Amount (lighter shade)

Any help is GREATLY appreciated.

and no.... checking supress zero values doesn't do anything....

ashfaq_haseeb — Tue, 19 Aug 2014 12:58:13 GMT

Hi,

Try by Go to chart --> Properties --> Presentation --> Select suppress zero value.

Or if you can share sample app it would be great.

Regards

ASHFAQ

Tue, 19 Aug 2014 13:33:31 GMT

is there any more information which would be helpful??

ashfaq_haseeb — Wed, 20 Aug 2014 06:13:08 GMT

You can attach that.

I have Licence I can open.

I will give you steps or screenshots you can replicate at your end.

Regards

ASHFAQ