Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

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: