Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmac1971
Contributor 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

Re: Top 10 In Straight Table

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

- Marcus

4 Replies
Not applicable

Re: Top 10 In Straight Table

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

Re: Top 10 In Straight Table

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

- Marcus

dmac1971
Contributor II

Re: Top 10 In Straight Table

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

Re: Top 10 In Straight Table

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

Community Browser