Calcul dynamique

[eprehu]

J'aimerais calculer le ratio en fonction du customer nationality country/nombre total => exemple nombre de client china/compte client => 42% =>

count(
{<
$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel)"},
$(var_Report_Date), $(var_Reporting_Currency),[Customer Nationality Country] = {'China Mainland'}
>}
distinct$(var_Customer_Key_Saleforce)
)
/
count(
{<
$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel)"},
$(var_Report_Date), $(var_Reporting_Currency)
>}
distinct$(var_Customer_Key_Saleforce)
)

Mais j'aimerais afficher le top 5 des pourcentages comme cela : 

J'aimerais transformer le calcul dynamiquement pour ne pas avoir le china mais je ne sais pas comment

Pouvez vous m'aider?

Merci!

[vinieme12 · Accepted solution]

Use the TOTAL keyword 

=count(

{<

$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel)"},

$(var_Report_Date), $(var_Reporting_Currency)

>}

distinct$(var_Customer_Key_Saleforce)

)

/

count(

{<

$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel) "},

$(var_Report_Date), $(var_Reporting_Currency)

>}

distinct    TOTAL $(var_Customer_Key_Saleforce)

)

[vinieme12]

Refer 

https://community.qlik.com/t5/QlikView-App-Dev/Keywords-TOTAL-ALL-DISTINCT/m-p/143516

[eprehu]

Thanks a lot !!!!!!

[vinieme12]

please close resolved threads by marking a response as a solution