Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension limit in straight table

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

9 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Set the ;limit to 6

buzzy996
Master II
Master II

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

use thi,PFA.

Not applicable
Author

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

Not applicable
Author

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
MVP
MVP

Use calculated dimension like attached qvw.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Master II
Master II

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

morganaaron
Specialist
Specialist

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
Specialist II
Specialist II

@Hi Ryan,

instead of dimension limits you can write simple calculated condition

plz find the at @tached