Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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.

Community Browser