Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
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)
12 Replies
vijetas42
Specialist
Specialist
Author

tried this too but, getting more than 50 rows

vijetas42
Specialist
Specialist
Author

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?