Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator II
Creator II

Top 10 In Straight Table

So I have a straight table with quite a few dimensions and one expression :

Sum ({<STATUS = {'OPEN'}, TYPE = {'TECH},LOCATION = {'UK'}>} AGE)

How can I limit the table to the top 10 oldest tickets based on this expression? TIA!

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Within the object-properties to this table is a tab restrictions - here you could specify this quite easily.

- Marcus

View solution in original post

4 Replies
Not applicable

You sort per value and in the properties the chart, on sheet Dimension Limits, you need to check restrict which values are displayed using the first expression.

Regards

Marcos Freire

marcus_sommer
MVP & Luminary
MVP & Luminary

Within the object-properties to this table is a tab restrictions - here you could specify this quite easily.

- Marcus

View solution in original post

dmac1971
Creator II
Creator II
Author

Ahhhh I had show other values ticked, hence it didn't work previously.  Thanks all!

Kush
MVP
MVP

Go to chart properties-> Dimension limit -> check restrict which values are displayed using the first expression. -> Select largest and Values =10