topic % Retained Customers in QlikView https://community.qlik.com/t5/QlikView/Retained-Customers/m-p/811302#M286382 <HTML><HEAD></HEAD><BODY><P>Does anyone have a working example of Customer Retained where the aggregation level changes based on the dimension viewed.</P><P></P><P>I have a case where I would like to compute Retained Customers based on Base Customers (n) months ago in the same time period.</P><P></P><P>Customer could be Retained on Global, but not on a Country or County level.</P><P></P><P>So the aggregation is different based on the X-Axis in the dimension.</P><P></P><P>I have a working application where the expression is super slow since I have to first compute an AGGR() of the base list of Customers (n) months, then get a COUNT(DISTINCT Customers)</P><P></P><P>This is too expensive on CPU for just 6M unique records.</P><P></P><P>Is there a better way to compute Retained information where we can push this into the load script or a more efficient way to get A * B where A is base list of customers, B is current list of customers.</P></BODY></HTML> Mon, 16 Mar 2015 16:39:14 GMT 2015-03-16T16:39:14Z % Retained Customers https://community.qlik.com/t5/QlikView/Retained-Customers/m-p/811302#M286382 <HTML><HEAD></HEAD><BODY><P>Does anyone have a working example of Customer Retained where the aggregation level changes based on the dimension viewed.</P><P></P><P>I have a case where I would like to compute Retained Customers based on Base Customers (n) months ago in the same time period.</P><P></P><P>Customer could be Retained on Global, but not on a Country or County level.</P><P></P><P>So the aggregation is different based on the X-Axis in the dimension.</P><P></P><P>I have a working application where the expression is super slow since I have to first compute an AGGR() of the base list of Customers (n) months, then get a COUNT(DISTINCT Customers)</P><P></P><P>This is too expensive on CPU for just 6M unique records.</P><P></P><P>Is there a better way to compute Retained information where we can push this into the load script or a more efficient way to get A * B where A is base list of customers, B is current list of customers.</P></BODY></HTML> Mon, 16 Mar 2015 16:39:14 GMT https://community.qlik.com/t5/QlikView/Retained-Customers/m-p/811302#M286382 2015-03-16T16:39:14Z