Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Specialist

## Top n in Qliksense straight table

Hi All,

I am facing issue while showing top 50 records in qliksense straight table.

I have applied limit top 50 on dimension it didn't work.

I have written expression using Rank function still it didn't work.

I have 5 dimensions and 7 expressions in table.

I have tried below expressions,

=if(rank(\$(exp_Sales_Delta)) <= 50,\$(exp_SalesGbp))

=if(rank(\$(exp_SalesGbp)) <= 50,\$(exp_SalesGbp))

even on one of the expression,

=if(rank(\$(exp_SalesGbp)) <= 50, Aggr(\$(exp_SalesGbp), [Issuer Name]))

Labels (2)

• ### Visualization

12 Replies
Master

Possibly as a calculated dimension while suppressing null values.

=Aggr(If(Rank(\$(exp_SalesGbp))<=50, [Issuer Name]), [Issuer Name])

Specialist
Author

do we need to do this for all the dimensions? as, with only this one it's not working.

Master

What is this "exp_SalesGbp" variable made up of? Post some sample.

Creator

here iam giving you an example expression and i hope it works for you.

aggr(if(rank(sum([Sales]))<=5, City), City)

Please like and accept the solution if u you find an answer

Specialist
Author

this is like, variable for current cob sales

Replace(Replace('sum({<[COB Date] = {^~(v_CurrentCOB)^}>} [Sales Gbp])','~','\$'),'^',Chr(39))

Specialist
Author

this is like, variable for current cob sales

Replace(Replace('sum({<[COB Date] = {^~(v_CurrentCOB)^}>} [Sales Gbp])','~','\$'),'^',Chr(39))

Specialist
Author

this one also I have tried but, seems not working

Master

Hello, you don't have to apply to every dimension that is used.

But first of all replace \$(exp_SalesGbp)) with \$(=\$(exp_SalesGbp)))

MVP

Try this

=Aggr(If(Rank(\$(exp_SalesGbp)) <= 50, \$(exp_SalesGbp)), [YourDimension])

Tags
Community Browser