Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bilionut
New Contributor II

Dimension Limit with negative value

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?

1.jpg

6 Replies
MVP
MVP

Dimension Limit with negative value

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.

bilionut
New Contributor II

Re: Dimension Limit with negative value

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."

MVP
MVP

Dimension Limit with negative value

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.

bilionut
New Contributor II

Re: Dimension Limit with negative value

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

2.jpg

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

MVP
MVP

Re: Dimension Limit with negative value

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

bilionut
New Contributor II

Re: Dimension Limit with negative value

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

Community Browser