topic Expression Meaning in QlikView https://community.qlik.com/t5/QlikView/Expression-Meaning/m-p/1408520#M426263 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can someone please help me understand the below expression written in Qlikview?</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">=</SPAN></P><P>if(SecondaryDimensionality()=0 ,</P><P>sum(aggr(</P><P>&nbsp; count(DISTINCT {&lt;S02_Expected_Registration_Date_View={"*"}-{"*Q*"}&gt;} </P><P>if(</P><P>if(Aggr(nodistinct </P><P>min({&lt;S02_Lead_Result_Flag={1}&gt;}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,</P><P>if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))</P><P>)</P><P>,S02_L_Dealer_Lead_Status_J,S02_Expected_Registration_Date_View))</P><P>,</P><P>count(DISTINCT </P><P>if(</P><P>if(Aggr(nodistinct </P><P>min({&lt;S02_Lead_Result_Flag={1}&gt;}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,</P><P>if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))</P><P>)</P><P>)</P></BODY></HTML> Fri, 01 Dec 2017 02:34:51 GMT Muthu 2017-12-01T02:34:51Z Expression Meaning https://community.qlik.com/t5/QlikView/Expression-Meaning/m-p/1408520#M426263 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can someone please help me understand the below expression written in Qlikview?</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">=</SPAN></P><P>if(SecondaryDimensionality()=0 ,</P><P>sum(aggr(</P><P>&nbsp; count(DISTINCT {&lt;S02_Expected_Registration_Date_View={"*"}-{"*Q*"}&gt;} </P><P>if(</P><P>if(Aggr(nodistinct </P><P>min({&lt;S02_Lead_Result_Flag={1}&gt;}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,</P><P>if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))</P><P>)</P><P>,S02_L_Dealer_Lead_Status_J,S02_Expected_Registration_Date_View))</P><P>,</P><P>count(DISTINCT </P><P>if(</P><P>if(Aggr(nodistinct </P><P>min({&lt;S02_Lead_Result_Flag={1}&gt;}S02_Dealer_Lead_Status_Level),S02_Customer_Id)=S02_Dealer_Lead_Status_Level,1,0)=1,</P><P>if(S02_Dealer_Lead_Status_Level=S02_L_Dealer_Lead_Status_Level,S02_Customer_Id))</P><P>)</P><P>)</P></BODY></HTML> Fri, 01 Dec 2017 02:34:51 GMT https://community.qlik.com/t5/QlikView/Expression-Meaning/m-p/1408520#M426263 Muthu 2017-12-01T02:34:51Z Re: Expression Meaning https://community.qlik.com/t5/QlikView/Expression-Meaning/m-p/1408521#M426264 <HTML><HEAD></HEAD><BODY><P>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 ..</P></BODY></HTML> Fri, 01 Dec 2017 05:26:16 GMT https://community.qlik.com/t5/QlikView/Expression-Meaning/m-p/1408521#M426264 Anil_Babu_Samineni 2017-12-01T05:26:16Z