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

[vijetas42]

tried this too but, getting more than 50 rows

[vijetas42]

this is not working at all.

[Kushal_Chawda]

@vijetas42  when you say top 50 on what basis top 50? As you mentioned you have 7 expressions, so top 50 records based on Top 50 sales across all dimensions?