Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
prajapatiamar38
Contributor II

Ranking

Hi Experts.....

i want to give a proper ranking to expression...
i had used rank 1,1 format...
m getting following output..

  

valuerank((value),1,1)
101
202
202
304
405
506
506
506
609
8010

expected output

  

valueExpected_rank
101
202
202
303
404
505
505
505
606
807

plz Help me..
thanks in advance...

3 Replies

Re: Ranking

Try,

Expression - Rank( Total sum(Value))

prajapatiamar38
Contributor II

Re: Ranking

i had used the same expression...
but not giving output with the same.....

MVP
MVP

Re: Ranking

Maybe like attached.