Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator III
Creator III

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

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

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

- Marcus

dmac1971
Creator III
Creator III
Author

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

Kushal_Chawda

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