Qlikview Limit Dimension to 5 rows from 17

[#1]

Hi All

I have a field which rank field in my data. I ranks somethings 1 to 20.

The issue is i only want to the first 5 in my table. Is there any way of doing this without using either a listbox / bookmark. Can i automatically program my Dimension to only show ranks 1 - 5?

Many thanks

[whiteline · Accepted solution]

In 11 version you can use dimension limits for chart dimensions.

In 10 you can try to use calculated dimension:

=aggr(if((your ranking expression) < 5, [Dimension], null()), [Dimension])

[#3]

Hi

Thanks for the quick reply. Data is still being returned for the for the rest of the ranks greater than 5. Although these are all aggregated under the dimension header ‘-‘.

I want a way of only showing ranks 1 – 5 and totally excluding 6 and above.

[whiteline]

Check 'Supress when Value is Null' for that dimension.