Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can someone please help me understand the below expression written in Qlikview?
=
if(SecondaryDimensionality()=0 ,
sum(aggr(
count(DISTINCT {<S02_Expected_Registration_Date_View={"*"}-{"*Q*"}>}
if(
if(Aggr(nodistinct
min({<S02_Lead_Result_Flag={1}>}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,
if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))
)
,S02_L_Dealer_Lead_Status_J,S02_Expected_Registration_Date_View))
,
count(DISTINCT
if(
if(Aggr(nodistinct
min({<S02_Lead_Result_Flag={1}>}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,
if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))
)
)
this is long expression, Are you needed explanation. Read each topic in your expression which covers all functionalities. So, Then it will understand more than ex plainer ..