topic How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables? in QlikView

How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

Wed, 27 Aug 2014 15:10:18 GMT

Dear Gurus

When I'm trying to create expression for pop-up labels for bar chart, I'm getting huge gap between y-axis and bars. Is there any solution to get rid of this. Please find below screen shot for more info

Normal chart before applying expression for pop-up lables

New Expression added for pop-up labels

Gap between y-axis and bars

Thank you.

Regards,

Srinivasu

Re: How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

Anonymous — Wed, 27 Aug 2014 15:20:08 GMT

there must be a null value in your countries list. how does your dimension tab look? did you try checking suppress null values?

Re: How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

Wed, 27 Aug 2014 15:39:57 GMT

Thanks for your reply Saradhi. I think there is no null values.... Please find below script which I added

LOAD * Inline [

Country, Sales $, Costs $

Germany, 900, 1000,

Japan, 600, 400,

UK, 800, 700,

USA, 1000, 800

];

Re: How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

Anonymous — Wed, 27 Aug 2014 15:58:27 GMT

np....something funky going on. i am unable to replicate it on my end. looks good when i try it.

Re: How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

ThornOfCrowns — Wed, 27 Aug 2014 16:00:54 GMT

Hi,

this also works for me. Try changing the type from Bar Chart to Combo chart to see if that makes a difference.

Re: How can we avoid Gap between bars and y-axis if we are inserting new expression for pop-up lables?

Anonymous — Wed, 27 Aug 2014 16:02:01 GMT

Press <Ctrl><Shift> at the same time and red bars will appear around the sub objects of your Bar Chart, whilst still pressing them right click one of the red lines and move it to re-size the object you wish to re-size / move.