Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Use variables as dimension and map variables with other tables

Hello !

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.

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.

What is the easiest way to do that ?

Thanks in advance !