Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

rank in script

hugmarcel
Contributor III

rank in script

Hi

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

Attachments
Comments
dafnis14
Contributor III

Hi Marcel,

This is great!

Thanks for sharing!

florentina_doga
Contributor III

nice. pretty good

jcooney1
New Contributor III

Thanks!

thigobr83
New Contributor III

Helped and very much.

Tks

matheus_silva
Contributor

Where i learn to make scripts like this?...

ghilenasma
New Contributor III

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

ee.PNG

can you give me some advice !!

hugmarcel
Contributor III

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.

ghilenasma
New Contributor III

that's it     

yes that exactly what i want they are groupped by Article

hugmarcel
Contributor III

Hi

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.

Regards - Marcel

ghilenasma
New Contributor III

i tried but that give me autonumber dosen't gave me rank  sorted  by price

Version history
Revision #:
1 of 1
Last update:
‎11-15-2015 05:39 AM
Updated by: