Documents for QlikView related information.
see my example file rank.qvw.
- it contains a sub providing flexible ranking mechanisms, such as ranking by autonumber or by row().- ranks can be split into half ranks for identical values (e.g. rank 11,12 -> 11.5, 11.5)
- ranking in total, by group and subgroups possible
- it should be easily possible to add more features as "use lowest value", "use highest value" as in UI rank function,
for identical ranking values.
Regards - Marcel
This is great!
Thanks for sharing!
nice. pretty good
Helped and very much.
Where i learn to make scripts like this?...
hi i like u'r great tutorial and i konw that you are the only one that can help me
but the problem that i can't achive this because autonumber can't give me result
can you give me some advice !!
Sorry I do not understand what your Goal is. Want to sort Cle by Prix? Cle and Code de l'article are identical in your Groups.
yes that exactly what i want they are groupped by Article
I have uploaded an improved version of rank.qvw.
Improvements:- Ranking by Groups and Subgroups ([Product Group],[Produkt]) instead of Groups only ([Product Group])- New Parameter vRankAsField added
Try to use 3 different CALL RankQVTable examples as given in the Script.
i tried but that give me autonumber dosen't gave me rank sorted by price