Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
)
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)
)
Refer
https://community.qlik.com/t5/QlikView-App-Dev/Keywords-TOTAL-ALL-DISTINCT/m-p/143516
Thanks a lot !!!!!!
please close resolved threads by marking a response as a solution