Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gr_eldred
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

8 Replies
Anonymous
Not applicable

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)

??

gr_eldred
Creator II
Creator II
Author

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

Anonymous
Not applicable

is There a possibility to upload the Qvd?

gr_eldred
Creator II
Creator II
Author

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

gr_eldred
Creator II
Creator II
Author

so are the data.

datos1.png

Anonymous
Not applicable

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

Ajuda.PNG

gr_eldred
Creator II
Creator II
Author

este es el qvd

shivanisali
Partner - Contributor II
Partner - Contributor II

PFA.