Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

ranking in a percentage

Hi, I need help to calculate a ranking on a column.

I need you to show as number one that has the highest percentage, number 2 that has the second best percentage, etc.

The ranking is with respect to the first column.

Can anybody help me please?

I attach my set

aggr(rank(num(AVG({$<Clasificación={'Mac'}, Fecha_Fin_Semana ={"<=$(=Max({1}Fecha_Fin_Semana))"}>}Cant6W)),1),Cant6W)

6wbl.png

Tags (2)
8 Replies
Highlighted
Contributor III
Contributor III

Re: ranking in a percentage

this Last Column "Rank" contains the value of :

aggr(rank(num(AVG({$<Clasificación={'Mac'}, Fecha_Fin_Semana ={"<=$(=Max({1}Fecha_Fin_Semana))"}>}Cant6W)),1),Cant6W)

??

Highlighted
Creator II
Creator II

Re: ranking in a percentage

is the column with which you try to get the rank with respect to the first column but does not put in all the rows a rank

Highlighted
Contributor III
Contributor III

Re: ranking in a percentage

is There a possibility to upload the Qvd?

Highlighted
Creator II
Creator II

Re: ranking in a percentage

I do not know how to upload this qvd I do not see any option to upload

Highlighted
Creator II
Creator II

Re: ranking in a percentage

so are the data.

datos1.png

Highlighted
Contributor III
Contributor III

Re: ranking in a percentage

When u are answering click to "use advanced Editor" Something like that, and then click to Attach.

Ajuda.PNG

Highlighted
Creator II
Creator II

Re: ranking in a percentage

este es el qvd

Highlighted
Partner
Partner

Re: ranking in a percentage

PFA.