Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
eprehu
Contributor III
Contributor III

Calcul sans selection filtre

Bonjour,

J'ai sélectionné le client segment sur VIC : 

eprehu_0-1655469966346.png

et j'ai un calcul qui ne prend pas un compte la selection et un autre si. Mais celui qui ne prend pas en compte la selection ne fonctionne pas.

Calcul de base : 

count(distinct
aggr(nodistinct {<[Report Date]>}
If(([Global Contactable] = 'true') and
sum(
{<
[Report Date], $(var_Reporting_Currency), [@QV_GIV.SOURCE]={'Sales'} ,
$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel_LLY)"},
[Customer First Purchase Date]={">=$(var_Date_Sel_LLY) <=$(var_Date_Sel)"}
>}
[Recruited Flag]
)=1,
[Customer Key]
),
[Customer Key]
)
)

Calcul qui ne prend pas en compte la selection du filtre: 

count({<[Segment LVMH Label]>} distinct
aggr(nodistinct {<[Report Date], [Segment LVMH Label]>}
If(([Global Contactable] = 'true') and
sum(
{<
[Report Date], $(var_Reporting_Currency), [@QV_GIV.SOURCE]={'Sales'} ,
$(var_Customer_Begin_Date_Saleforce)={"<=$(var_Date_Sel)"}, $(var_Customer_End_Date_Saleforce)={">=$(var_Date_Sel_LLY)"},
[Customer First Purchase Date]={">=$(var_Date_Sel_LLY) <=$(var_Date_Sel)"}, [Segment LVMH Label]
>}
[Recruited Flag]
)=1,
[Customer Key]
),
[Customer Key]
)
)

 

 

Labels (1)
1 Reply
eprehu
Contributor III
Contributor III
Author

eprehu_0-1655470225611.png

le filtre client segment est bien le segment lvmh label