topic Calculated Dimension in App Development https://community.qlik.com/t5/App-Development/Calculated-Dimension/m-p/1620841#M46827 <P>Hi,</P><P>I need Repeated Customers Analysis, how to write the Calculated Dimension for Only last visited Sales .</P><P>for Example,</P><P>In below mentioned table, Rank 3 is last visited sales.So, in Calculated Dimension I want display Rank 3 Record only.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><FONT size="2">Rank</FONT></TD><TD><FONT size="2">DocNum</FONT></TD><TD><FONT size="2">DocDate</FONT></TD><TD><FONT size="2">CountyB</FONT></TD><TD><FONT size="2">Brand</FONT></TD><TD><FONT size="2">Segment</FONT></TD><TD><FONT size="2">Sales</FONT></TD></TR><TR><TD><FONT size="2">1</FONT></TD><TD><FONT size="2">1911100895</FONT></TD><TD><FONT size="2">07-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">PREETHI</FONT></TD><TD><FONT size="2">MIXE</FONT></TD><TD><FONT size="2">3100</FONT></TD></TR><TR><TD><FONT size="2">2</FONT></TD><TD><FONT size="2">1911100943</FONT></TD><TD><FONT size="2">08-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">CROMPTON</FONT></TD><TD><FONT size="2">AIRCOOLER</FONT></TD><TD><FONT size="2">5099.99</FONT></TD></TR><TR><TD><FONT size="2">2</FONT></TD><TD><FONT size="2">1911100943</FONT></TD><TD><FONT size="2">08-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">VENUS</FONT></TD><TD><FONT size="2">FAN</FONT></TD><TD><FONT size="2">1000</FONT></TD></TR><TR><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>3</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>1911101297</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>21-05-19</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>6374860082</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>CROMPTON</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>ACCESSORIES</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>390.01</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have written this Expression</P><P>=Aggr(if(Rank(Total Sum(LineTotal_WithTax))/Count(distinct{&lt;CustPhoneNo = {"=Rank(Total count(distinct DocDate))=2"}&gt;}CustPhoneNo),'2 Times'),CustPhoneNo)</P><P>its not working.</P><P>Anybody please help me. how to write the set expression and Calculated Dimension.</P> Fri, 06 Sep 2019 06:26:29 GMT Ram83 2019-09-06T06:26:29Z Calculated Dimension https://community.qlik.com/t5/App-Development/Calculated-Dimension/m-p/1620841#M46827 <P>Hi,</P><P>I need Repeated Customers Analysis, how to write the Calculated Dimension for Only last visited Sales .</P><P>for Example,</P><P>In below mentioned table, Rank 3 is last visited sales.So, in Calculated Dimension I want display Rank 3 Record only.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><FONT size="2">Rank</FONT></TD><TD><FONT size="2">DocNum</FONT></TD><TD><FONT size="2">DocDate</FONT></TD><TD><FONT size="2">CountyB</FONT></TD><TD><FONT size="2">Brand</FONT></TD><TD><FONT size="2">Segment</FONT></TD><TD><FONT size="2">Sales</FONT></TD></TR><TR><TD><FONT size="2">1</FONT></TD><TD><FONT size="2">1911100895</FONT></TD><TD><FONT size="2">07-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">PREETHI</FONT></TD><TD><FONT size="2">MIXE</FONT></TD><TD><FONT size="2">3100</FONT></TD></TR><TR><TD><FONT size="2">2</FONT></TD><TD><FONT size="2">1911100943</FONT></TD><TD><FONT size="2">08-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">CROMPTON</FONT></TD><TD><FONT size="2">AIRCOOLER</FONT></TD><TD><FONT size="2">5099.99</FONT></TD></TR><TR><TD><FONT size="2">2</FONT></TD><TD><FONT size="2">1911100943</FONT></TD><TD><FONT size="2">08-05-19</FONT></TD><TD><FONT size="2">6374860082</FONT></TD><TD><FONT size="2">VENUS</FONT></TD><TD><FONT size="2">FAN</FONT></TD><TD><FONT size="2">1000</FONT></TD></TR><TR><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>3</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>1911101297</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>21-05-19</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>6374860082</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>CROMPTON</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>ACCESSORIES</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" size="2" color="#008000"><STRONG>390.01</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have written this Expression</P><P>=Aggr(if(Rank(Total Sum(LineTotal_WithTax))/Count(distinct{&lt;CustPhoneNo = {"=Rank(Total count(distinct DocDate))=2"}&gt;}CustPhoneNo),'2 Times'),CustPhoneNo)</P><P>its not working.</P><P>Anybody please help me. how to write the set expression and Calculated Dimension.</P> Fri, 06 Sep 2019 06:26:29 GMT https://community.qlik.com/t5/App-Development/Calculated-Dimension/m-p/1620841#M46827 Ram83 2019-09-06T06:26:29Z