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]))
tried this too but, getting more than 50 rows
this is not working at all.
@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?