topic Use variables as dimension and map variables with other tables in QlikView https://community.qlik.com/t5/QlikView/Use-variables-as-dimension-and-map-variables-with-other-tables/m-p/434510#M489782 <HTML><HEAD></HEAD><BODY><P>Hello !</P><P>I've set up a few variables (vRecency, vFrequency, vMonetary) looking if if a customer, for example bought over 1000euro (vRencency = 2), 5 times (vFrequency = 5), and hasn't bought in 3 months (vRecency =1). I'd like to create groups of customers based on those variables and combinations of variables (ex: 2/5/1 = "good customer"). I've created another table with the combinations that I would like to link with the variables.</P><P>Then I also want to be able to create a pivot with groups like "good customer" and look at their sales in the past 12 months for examples.</P><P>What is the easiest way to do that ?</P><P>Thanks in advance !</P><P>T</P></BODY></HTML> Wed, 14 Nov 2012 23:50:29 GMT 2012-11-14T23:50:29Z Use variables as dimension and map variables with other tables https://community.qlik.com/t5/QlikView/Use-variables-as-dimension-and-map-variables-with-other-tables/m-p/434510#M489782 <HTML><HEAD></HEAD><BODY><P>Hello !</P><P>I've set up a few variables (vRecency, vFrequency, vMonetary) looking if if a customer, for example bought over 1000euro (vRencency = 2), 5 times (vFrequency = 5), and hasn't bought in 3 months (vRecency =1). I'd like to create groups of customers based on those variables and combinations of variables (ex: 2/5/1 = "good customer"). I've created another table with the combinations that I would like to link with the variables.</P><P>Then I also want to be able to create a pivot with groups like "good customer" and look at their sales in the past 12 months for examples.</P><P>What is the easiest way to do that ?</P><P>Thanks in advance !</P><P>T</P></BODY></HTML> Wed, 14 Nov 2012 23:50:29 GMT https://community.qlik.com/t5/QlikView/Use-variables-as-dimension-and-map-variables-with-other-tables/m-p/434510#M489782 2012-11-14T23:50:29Z