
Re: Sum of rank
omar bensalem Apr 3, 2017 3:20 PM (in response to Salim DERGHOUM)Can you post an image of what you have?
your measure?
And what you want to calculate and where?
Or even better, can you put your sample qvf file to work with?
Thanks

Re: Sum of rank
Salim DERGHOUM Apr 3, 2017 3:23 PM (in response to Salim DERGHOUM)I use this formula, but she return nothing :
Aggr(Sum({<nom_Mesure={exp}>} valeur),
if(rank(if(((sum({<nom_Mesure={exp}>} valeur)/sum({<nom_Mesure={exp}>}total<nom_Du_Pays> valeur))*100)<=1,
((sum({<nom_Mesure={exp}>} valeur)/sum({<nom_Mesure={exp}>}total<nom_Du_Pays> valeur))*100)))<=5,
code_Produit))


Re: Sum of rank
Salim DERGHOUM Apr 3, 2017 3:43 PM (in response to omar bensalem )Yes, I want this but I want total in each line.

Re: Sum of rank
Salim DERGHOUM Apr 3, 2017 3:59 PM (in response to omar bensalem )Thanks for you sample, I success but do you know if I can put this formula in variable ?
Sum(total Aggr(if(rank(if(((sum({<nom_Mesure={exp}>} valeur)/sum({<nom_Mesure={exp}>}total<nom_Du_Pays> valeur))*100)<=1,
((sum({<nom_Mesure={exp}>} valeur)/sum({<nom_Mesure={exp}>}total<nom_Du_Pays> valeur))*100)))<=5,
sum({<nom_Mesure={exp}>} valeur)), code_Produit))
Thanks again


Re: Sum of rank
Salim DERGHOUM Apr 3, 2017 3:38 PM (in response to Salim DERGHOUM)It's the windows named "one" and the measure named "Exp/pop" of the table. Before, my formula calculated total exportation of one country in relation with population of this country. But now, I want calculate only the value total of the export of the top 5 for one country.

projet.qvf 256.0 K



Re: Sum of rank
omar bensalem Apr 3, 2017 4:00 PM (in response to Salim DERGHOUM)This what I've done with a sample app I have,
See the attached app
Now, stalwar1, the field is yours

Rank function.qvf 176.0 K



Re: Sum of rank
Salim DERGHOUM Apr 4, 2017 4:19 AM (in response to omar bensalem )I do it this in first, but my problem it's I wished the Top N values of exp inferior(or superior) at X%. So it's not working fine like with rank function.
