topic stacked bars disappearing in QlikView

stacked bars disappearing

Fri, 24 Jun 2011 06:28:46 GMT

hi guys, i have this weird problem

my bar charts work fine with the 15 expressions and location as the dimensions, they work fine with the default Grouped style

however, when i change it to Stacked all the bars disappear. when i randomly disable a few expressions some bars will appear again. when i disable more expressions, i can eventually get all bars to appear...

are there any settings i need to take note off?

stacked bars disappearing

kaushiknsolanki — Fri, 24 Jun 2011 06:36:03 GMT

Hi,

Try this.

Go to properties-> Presentation-> Select Show all bars.

Regards,

Kaushik Solanki

stacked bars disappearing

Fri, 24 Jun 2011 06:42:07 GMT

hi Kaushik thanks for your reply,

Show All Bars does not work

however when i check Forced 0 for all expressions, they come back again

and yes i do have zeroes in some values but i didn't know that would matter...

stacked bars disappearing

kaushiknsolanki — Fri, 24 Jun 2011 06:56:18 GMT

Hi,

Zeros are the problem. When you have stack bars they would disappear as there is no value.

Regards,

Kaushik Solanki