topic Re: Dimension Limit with negative value in QlikView

Dimension Limit with negative value

bilionut — Wed, 21 Dec 2011 09:20:05 GMT

Perhaps I've been not to clear here: http://community.qlik.com/message/172046#

Here's a more simple example:

I make two Straight Table with Dimension Limit set as in the picture.

I don't understand why negative values are also displayed?

How can I avoid displaying negative values?

Dimension Limit with negative value

jagan — Wed, 21 Dec 2011 09:32:45 GMT

Hi,

In version 9, there is a tab called Axis, in that tab there is "Scale" section in that we should set the Static Max and Min values.

But in the above screenshot i didn't found that.

You can also handle this in expression by using

if(Sum(Field) < 0, 0, Sum(Field))

Hope this helps you.

Regards,

Jagan.

Re: Dimension Limit with negative value

bilionut — Wed, 21 Dec 2011 12:39:18 GMT

It is a new feature at QlikView 11.

Quote from QV11 Reference Manual:

"Dimension Limits

QlikView has had the capability to present "Others" and "Totals" values in various chart types. QlikView also allows users to configure charts to display the top or bottom X values in several charts. All of this manipulation was previously managed by the charting engine. Starting with QlikView 11, these capabilities have been moved to the calculation engine. This means users will be able to set these options across all chart types, except for Gauge Charts and Pivot Tables. There is a new tab in the chart property dialog called Dimension Limits that allows users to configure these options."

Dimension Limit with negative value

swuehl — Wed, 21 Dec 2011 14:19:38 GMT

That's an interesting one!

I carefully read the QV11 manual about this new feature and I would also expect the negative values to be excluded, if we were using option "largest values" or "first values (in sort order)" with first expression sorted by descending numerical value.

Seems like a bug to me (Not the first one ), though you can maybe workaround this like Jagan suggested.

Re: Dimension Limit with negative value

bilionut — Thu, 22 Dec 2011 07:46:31 GMT

Yes, it's probably a bug. I tried what Jagan suggested, but for some particular values I get incorrect results for "Others" total.

I think -3 is the correct values for Others and 80% is calculated only for positive values.

Re: Dimension Limit with negative value

swuehl — Thu, 22 Dec 2011 11:58:28 GMT

I see. I think you can't assure then that you get correct values for the Customer TopX list, Others and Total if you have also negative values. Jagan's expression is cutting off negative values, so you get a different set of values anyway.

As said, to me it's a bug since the function delivers not what we expect when reading the manual and interpreting the dimension limit dialog.

Hopefully QT will fix this in the next SR (ot at least clarify how this function is supposed to work).

Regards,

Stefan

Re: Dimension Limit with negative value

bilionut — Thu, 22 Dec 2011 14:52:06 GMT

Furthermore, if you apply Dimension Limit on a range of negative values only, it does not produce any change.