Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER

rank in script

hugmarcel
Specialist
Specialist

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
Specialist
Specialist

Hi Marcel,

This is great!

Thanks for sharing!

0 Likes
florentina_doga
Partner
Partner

nice. pretty good

0 Likes
jcooney1
Contributor III
Contributor III

Thanks!

0 Likes
thigobr83
Contributor III
Contributor III

Helped and very much.

Tks

0 Likes
matheus_silva
Creator
Creator

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

0 Likes
ghilenasma
Contributor III
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 !!

0 Likes
hugmarcel
Specialist
Specialist

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.

0 Likes
ghilenasma
Contributor III
Contributor III

that's it     

yes that exactly what i want they are groupped by Article

0 Likes
hugmarcel
Specialist
Specialist

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

0 Likes
ghilenasma
Contributor III
Contributor III

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

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