Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

to calculate rank (need replacement of over partition by )

Hi,

I have ID, Year, Country, Value in my table. I have to calculate rank for country for each ID and Year based on the value in script. More the value, best the rank.

For example, for year=2014, ID=1, I have value for 20 countries. I need ranking for them (so rank is from 1 to 20)

Similarly , I have more IDs for the same year, for which the rank should again start from 1.


Please suggest solution.

Thanks

2 Replies
Not applicable

Re: to calculate rank (need replacement of over partition by )

Try using the below expression :

Aggr(Rank(sum({$<Country={'*'}>}Value)), ID,Year)

Not applicable

Re: to calculate rank (need replacement of over partition by )

Hi Jhansi,

I want to calculate this in script, not in chart. Because I need to do further calculations after I get this result.

Community Browser