Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Dimension Limits - Top 80%

Can someone tell me why when I use the Dimension Limit 80% of Relative Total Using Largest Value, the lowest value is included?

Below are all my values sorted Descending (this is the first expression and I only have one Dimension)

All Values.PNG

and this is what I get when I set the dimension limit to accumulate to 80% of Relative Total Using Largest Value

Properties.PNG

Limited.PNG

shouldn't the record with a total of $5000 come next?

Tags (1)
14 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Dimension Limits - Top 80%

Can you post a Qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
Highlighted

Re: Dimension Limits - Top 80%

What is the sort order on your chart set to?

I would try sorting by Y-Value - descending

Highlighted

Re: Dimension Limits - Top 80%

Try selecting the "Include Boundary Values" and see if that helps.

Capture.PNG

Best,

Sunny

Highlighted
Not applicable

Re: Dimension Limits - Top 80%

Sorry I can't post the document, confidential info.

Highlighted
Not applicable

Re: Dimension Limits - Top 80%

When I select include Boundary Values, the record totaling $5000 is added to the results but the -110 still shows up.Boundary Values.PNG

Highlighted
Not applicable

Re: Dimension Limits - Top 80%

You can't sort by y-values in a straight table (x & y don't exist).  I tried sorting my dimension with first priority descending by the same expression formula and that didn't change anything.

Highlighted
Not applicable

Re: Dimension Limits - Top 80%

I added a % of total column and this is confusing me even more.  You reach 80% at the 10,265 line, so why are the other 3 included?  Is it sorting individual records and taking the top 80% before aggregation and then including records that aren't in the 80% in the aggregated result?

Percent of Total.PNG

Every day I work in QV I wish I was working in Tableau again.

Highlighted

Re: Dimension Limits - Top 80%

May be you want to restrict negative values in your expression, because negative value potentially reduces the total to be under 80%

{<Invoice = {'>0'}>}

Highlighted
antoniotiman
Honored Contributor III

Re: Dimension Limits - Top 80%

Hi Jessica,

I have already noticed this behaviour due to values < 0.

You don't use Dimension limits.

You use expression

If(RangeSum(Above(Sum(Sales),0,RowNo()))/Sum(TOTAL Sales) <= 0.8,Sum(Sales))

Dimension Product

Regards,

Antonio