Dimension Limit don't work (example attached )

[dferreirogft]

Good Afternoon,

I'm trying to get the dimension limits to work on a very simple straight table but I cannot understand what this option is doing.

I want Qlikview to return me thoose rows that aggregated sums up to the 80% of the total of the rows.

I have different results using qlikview capability or an embeded formula to manual calculate the limit.

Could someone help me?

[ali_hijazi]

this shows the top 3

sum({<pais={"=aggr(rank(sum(nro)),pais)<4"}>} nro)

you can put a variable instead of  hard-coded ranks e.g. 4

[qv_testing]

go to  Dimension Limits --> uncheck Show Others property

hope it helps

[dferreirogft]

Hi,

This is not what I aim for. This will show me the top 3, but not those rows that sum up the 80% of the total

[dferreirogft]

Already tried and, not working:

[sunny_talwar]

It's weird, I have used it in the past without issues... but even your expression one isn't correct... you need to sort by an expression to get the right result

[dferreirogft]

You're right. With the expression it works, but i need to know why it is not working with the usual flow.

It will be applied to a table with 20 expresions. So using expression like limit won't be a solution for me...

[qv_testing]

go to  Dimension Limits --> uncheck Show Others property

See attached..

[dferreirogft]

oh! it's magic... what did you do to solve it?

[sunny_talwar]

I am curious too