Dimension limit in straight table

[#1]

Hi i am using a straight table to show the country and number of counts.I  want to show 5 largest countries based on the count value and showing other countries with label 'others'.But when i set the dimension limit to 5 it only shows 4 countries and the 5th row as others.Actually i want to show  5 countries an then the  6th row as  total count of others.Any idea on how to achieve this in straight table. Below I have attcahed my sample qlikview

[jpenuliar]

Set the ;limit to 6

[buzzy996]

because of ur expression,ur getting like that...

use thi,PFA.

[#4]

Hi thank you for your help,but my actual scenario is that i don't want to show all the countries.I want to show the largest among those countries that i am specifying in my expression and show other countries count as 'others'.For example if  i am specifying 8 countries in my expression and i want to show 6 largest countries from those specified countries and take the count of other two countries as 'others'.

[#5]

when i set the limit to 6 it shows all countries and no other row appear in the table.My scenario is that i don't want to show all the countries.I want to show the largest among those countries that i am specifying in my expression and show other countries count as 'others'.For example if  i am specifying 8 countries in my expression and i want to show 6 largest countries from those specified countries and take the count of other two countries as 'others'.

[tresesco]

Use calculated dimension like attached qvw.

[Peter_Cammaert]

The dimension limit works as expected/designed:

• Either you sort by Y-value and you limit to the first 6 with the sixth reserved for others or the last one if there are only six
• Or you ignore the sort order and limit to the largest 6 (random order) with the sixth reserved for others or the last one if there are only six countries in your expression.

Add a 7th country to your set expression and increase the Limit value to 6. It'll work...

What's the use of forcibly calling the last of six countries others, if there is enough space to call it by name. That sounds like forcing QlikView to show a scrollbar when all field values can be displayed.in the available listbox space.

Best,

Peter

[buzzy996]

PFA,If u pass more than six in ur expression..u won't get that issue,

[morganaaron]

I agree with Peter, in that it makes little sense to be doing this, but see attached - the rank will give you the top X values, so change the "less than" value in the dimension to however many you want to show. The expression will then limit your "others" to those listed in the set but not less than the rank value.

Edit: I added the rank as an expression so you can see what this is doing - for your sample less than 5/6 will be the same due to the equal values attributed to some countries.

[sunilkumarqv]

@Hi Ryan,

instead of dimension limits you can write simple calculated condition

plz find the at @tached