Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Dharanidharan_DD
Contributor III
Contributor III

How to find rank only Considering single measure field in a table

Hi,

How to create rank field without considering dimensional fields .

Only based on one measure field.

I Have Measure field Sum(NetWt) , and many dimensions with repeated values . I need to rank only based on Sum(NetWt) field .

3 Replies
Taoufiq_Zarra
Master II
Master II

can you share a sample data and the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Dharanidharan_DD
Contributor III
Contributor III
Author

Rank Issue - Copy.JPG

Dharanidharan_DD
Contributor III
Contributor III
Author

I need to get Purchase Rank . Purely Based on Purchase Weight i.e Sum(NetWt).

I used this expression for purchase rank but I cant find rank num 3.

=aggr( nodistinct Rank( aggr(if(sum(NETWT)>0, sum(NETWT)),Quote,Touch),4),NETWT)