Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Add ranking to table

Hi,

I'm having a tables like this

idtechnologyversion
1412Java1.4
2341Java1.5
134Java1.6
2310.Net Framework3.0
14.Net Framework3.5
8012.Net Framework4.0

i want to add a ranking column which holds rank for each version

technology and version are sorted in ascending order

For example:

idtechnologyversionranking
1412Java1.43
2341Java1.52
134Java1.61
2310.Net Framework3.03
14.Net Framework3.52
8012.Net Framework4.01

Can anyone help ?

2 Replies
gautik92
Valued Contributor III

Re: Add ranking to table

Aggr(Rank(Sum(version),1,1),id)

MVP
MVP

Re: Add ranking to table

=Aggr(Rank(version), technology, id)

Community Browser