Expression Meaning

[Muthu]

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))

)

)

[Anil_Babu_Samineni]

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 ..