Need to hide bars with zero value

[qlikwiz123]

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.

I need to hide the budget and forecast from 12h2 through 13h2 so that there is no empty space in my graph. Since no data is available for Budget and Forecast through 12h2 through 13h2, there is this weird empty space but on 14h1, since there is data for all three, it looks full.

Any help is GREATLY appreciated.

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

Please look at Distribution 2 and Result Table for the empty bars chart. I need to remove those empty spaces (bars) with zero values.

[qlikwiz123]

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. Since no data is available for Budget and Forecast through 12h2 through 13h2, there is this weird empty space but on 14h1, since there is data for all three, it looks full.

Any help is GREATLY appreciated.

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

Please look at Distribution 2 and Result Table for the empty bars chart. I need to remove those empty spaces (bars) with zero values.

[qlikwiz123]

@rwunderlich

Hi Rob,

Thank you so much. I knew this way but it makes the chart look a bit odd. The Hierarchy of Quarters to Years or Vice Versa is gone when you combine the dimensions. Hence am restraining from going that route 😐

[Emirly]

Thanks, I had the same doubt, and it worked for me.

[raghuchowdary]

sol:

 use the cal dimension for actuals, forecast and budget in your chart,

if(isnull(aggr(sum(yourexpression for actuals or for or bud),dim))=0,dim)

here:dim=12H2 ...etc

it should work.