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: 
Not applicable

Top ten in straight table with two dimensions

Hi,

I have a straight table with the dimensions "ConsigneeCity" and "Consignee", and as expression the waiting time at the consignee. I want my table to only show the ten highes values, but if I select top ten in the "dimension limits" tab, my table keeps going on blank and shows "Allocated memory exceeded". How do I still get the top ten?

Load details.JPG

Load details2.JPG

1 Solution

Accepted Solutions
arjunkrishnan
Partner - Creator II
Partner - Creator II

Hello Frd ,

Use This Expression It Well Useful For U

To View It Top 10 City On 2 Dimensional Wise

if(aggr(Rank(Sum(waitingtime),10),ConsigneeCity)<=10,aggr(Sum(waitingtime),ConsigneeCity,Consignee))

View solution in original post

6 Replies
amit_saini
Master III
Master III

Hi Niek,

Please try this:

=aggr(if(Rank(sum(Your_Field))<=10,Your_Field),Your_Field) (For calculating Top 10)


Thanks,

AS

MK_QSL
MVP
MVP

Can you share your sample file please?

Not applicable
Author

Do as Amit suggests in a calculated dimension then check Suppress When Value Is Null for the dimension in Settings for Selected Dimension.

joachim_boivie
Partner - Contributor III
Partner - Contributor III

You can try this,

sum({<Value={"=rank(total aggr(sum(Value),Dim1,Dim2))<=$(vL.SetTopValue)"}>}Value)

The expression below is something I use for a dynamic top X function in my tables/charts. But its for one dimension only,

(Where the user selects the wanted dimension from the data island - Field) (The dimension is a calculated dim using following, $(=concat(Distinct Field)) )


sum({<$(=concat(Distinct Field))={"=rank(total aggr(sum(Value),$(=concat(Distinct Field))))<=$(vL.SetTopValue)"}>}Value)

its_anandrjs

For your dimension field use

Dimension1

Trim(ConsigneeCity)


Dimension2

Trim(Consignee)


Expression

Sum([Waiting time])


and in sort expression

Rank( sum( [Waiting time] ), 10 )


Hope this helps


arjunkrishnan
Partner - Creator II
Partner - Creator II

Hello Frd ,

Use This Expression It Well Useful For U

To View It Top 10 City On 2 Dimensional Wise

if(aggr(Rank(Sum(waitingtime),10),ConsigneeCity)<=10,aggr(Sum(waitingtime),ConsigneeCity,Consignee))