topic Re: Bar chart issue in QlikView

Bar chart issue

alec1982 — Thu, 06 Dec 2012 23:10:07 GMT

Hi Guys,

I have couple of simple bar charts. they both set to be horizontal charts. as I know if the value is positive it will show to the right and then if it is negative it will show to the left. such as what I am showing in the attached image(the left chart).

Not sure why the right chart is showing negative value to the right side on some dimenssions!

Hope someone can explain that to me so i can have consistent charts.

Thxs,

Alec

Re: Bar chart issue

Anonymous — Fri, 07 Dec 2012 04:54:07 GMT

Hi,

Can u share a sample file of it??

Thanks

Re: Bar chart issue

Anonymous — Fri, 07 Dec 2012 07:59:53 GMT

Strange. A few troubleshooting suggestions:

Turn your bar chart into a straight table to make sure it is a negative value.

Tick the Force zero and set the Min to '0' on the Axis sheet and see if this value still appears.

Check the Number format. Is it 'expression default' and are you setting the Num() formatting in the expression ?

Jonathan

Re: Bar chart issue

alec1982 — Fri, 07 Dec 2012 17:12:26 GMT

It is strange for sure!

The nr is negative when i use it somewhere else but on the chart is showing as negative nr for some reason. in fact if a filter on that dimension The nr move to the left.!!

Re: Bar chart issue

Anonymous — Sat, 08 Dec 2012 08:10:30 GMT

Perhaps recreate the chart or even the document to see if there is some sort of corruption. Else try on a different version.

Jonathan