Discussion Board for collaboration related to Creating Analytics for QlikView.
i have a table in which i want to know the rank of each dataset..
how to achieve that.
Go to Solution.
load * inline
autonumber(purchase) as rank
order by purchase desc;
drop table t1;
if you are calculating in chart then you can use rank() function...
if it is in script then use autonumber to generate the ranks for each dataset..
i want to implement it in script level...
data is like:
Can you please elaborate the problem... however you can try "rank" function...