If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 .
can you share a sample data and the expected output ?
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)