Top n in Qliksense straight table

[vijetas42]

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]))

[BrunPierre]

Possibly as a calculated dimension while suppressing null values.

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

[vijetas42]

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

[BrunPierre]

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

[Prem0212]

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

[vijetas42]

this is like, variable for current cob sales 

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

[vijetas42]

this is like, variable for current cob sales 

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

[vijetas42]

this one also I have tried but, seems not working

[BrunPierre]

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

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

[Chanty4u]

Try this 

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