Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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. Capture.PNG.png

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....

3 Replies
ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

is there any more information which would be helpful??

ashfaq_haseeb
Champion III
Champion III

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