Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

14 Replies
Gysbert_Wassenaar

Can you post a Qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
colin_albert

What is the sort order on your chart set to?

I would try sorting by Y-Value - descending

sunny_talwar

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

Capture.PNG

Best,

Sunny

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

sunny_talwar

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

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

antoniotiman
Master III
Master III

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