Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add rank # as column in straight table

I have a table with top 10 stores by sales and I want to assign ranks 1-10 based on their sales in a straight table.

Can this be done? If so, how?

Thank you,

Amit

3 Replies
mrichman
Creator II
Creator II

Try to use a chart object-> Straight table and add in expression.

=aggr(rank(sum({<District=>}Sales)),Sales)

surendraj
Specialist
Specialist

May be this!!

if(aggr(rank(sum(sales)>10,sum(sales))))

--Surendra

vishsaggi
Champion III
Champion III

Try:

= Aggr(Rank(Sum(Sales)) <=10, YourDimField)