topic Negative Zero on X axis in QlikView

Negative Zero on X axis

gaddeonline — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a combo chart with a dimension on Y axis and an expression on X axis. The expression resulting negative values including negative zeroes. How come there is a negative zero in the world?

Could you please guide me how to resolve this issue? I just want to see '0.0' on X axis, not '-0.0'.

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

neha_shirsath — Tue, 31 May 2016 11:51:17 GMT

Hi Mahesh,

In your Combo chart, you have any negative value like -0.003 or -0.002 etc when you round of to 2 digit it will give you -0.00 because of that it might be coming.

Check the same.

Or else can you put some data.

Regards,

Neha

Re: Negative Zero on X axis

gaddeonline — Wed, 01 Jun 2016 22:19:42 GMT

Hi Neha,

Thanks for your prompt response.

It's not actually '-0.0'. it is actually -5.6e-017. what's the best way to make it to '0'.

I am unable to attach any images for your consideration.

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

sunny_talwar — Wed, 01 Jun 2016 22:35:05 GMT

May be use

If(Expression <= 0 and Expression >= -1, Ceil(Expression), Expression)

Re: Negative Zero on X axis

gaddeonline — Wed, 01 Jun 2016 22:54:45 GMT

Hi Sunny,

I tried it already. but no use. My Expression is like 'a/b - c/d'. so it's dynamically changing the x-axis values(especially minimum and maximum on the axis). so nothing is working.

I tried round function like, Round(Expression*100)/100. but no use.

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

swuehl — Wed, 01 Jun 2016 22:58:00 GMT

If you really round the expression to two decimal places, I think the negative sign will not be shown

=Round(-0.00001,0.01)

should show 0.00

compared to just formatting the expression with two decimal places:

=Num(-0.00001,'0.00')

where you might see the minus sign -0.00

Re: Negative Zero on X axis

swuehl — Thu, 02 Jun 2016 09:09:32 GMT

Could you post a small sample QVW?

Note that Round(Expression*100)/100 might not return the same as what I've suggested above

Re: Negative Zero on X axis

gaddeonline — Thu, 02 Jun 2016 22:13:48 GMT

Hi Stefan,

Please refer the below images. I don't have rights to post any sample QVW's. Please let me know what to do to getrid of the negative values in x axis?

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

swuehl — Thu, 02 Jun 2016 22:36:36 GMT

Could you post screenshot from your chart settings tabs? Especially from dimensions, expression, axes and number tab?

Re: Negative Zero on X axis

gaddeonline — Thu, 02 Jun 2016 23:05:22 GMT

Hi Stefan,

Thanks for your prompt responses.

Here am attaching the screenshots of the tabs you asked for.

Thanks in advance.

Mahesh Gadde

Re: Negative Zero on X axis

gaddeonline — Tue, 07 Jun 2016 23:16:23 GMT

Hi Stefan,

swuehl‌

Did you get anything?

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

gaddeonline — Tue, 07 Jun 2016 23:20:55 GMT

Hi Stefan,

swuehl‌

I don't want to getrid of every negative value. All I want is to getrid of negative zero only.

Thanks and Regards

Mahesh Gadde

Re: Negative Zero on X axis

swuehl — Wed, 08 Jun 2016 21:51:16 GMT

Mahesh,

I can reproduce your issue and I believe it's a bug in the axis label calculation algorithm, in fact a kind of rounding error.

QV seems to calculate the min and max range of the chart, determines the number of labels it needs to show based on the settings in axis tab and some low artificial intelligence, and this should normally result on a label exactely at zero.

Apparently, the algorithm calculates a label that is positioned slightly different from zero, I assume due to a rounding error.

I believe this is totally independent from the values your expression return, and also occur with only positive expression values as long as the axis range ranges into negative domain.

Hence I don't think that the expressions we've suggested above will change anything.

Note that due to the assumed rounding error, small changes e.g. in numeric range used in the label algorithm might lead to observing or not observing the issue (e.g. also noticeable if you change the size of the chart, hence the number of labels),

I am attaching a sample to demonstrate the issue, and also a very, very dirty hack to show a positive zero for the exact same setting (but this will not work very well if you e.g. change the chart size).

I would suggest that you open a case with Qlik support to investigate the bug in axis labelling.

Re: Negative Zero on X axis

gaddeonline — Thu, 09 Jun 2016 00:46:41 GMT

Hi Stefan,

I appreciate your time and help in this matter.

I will let the community know if we got any positive result from Qlik Support.

Thanks everyone.

Regards

Mahesh Gadde