# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## dividing customers

Hello everyone,

I have a question about Qliksense.

I would like to divide my customers into 3 groups:

New customers (customers who have bought this month and never before)

Loyal customers (customers who bought this month and for that too)

Stopped customers (customers who have not bought this month and always dit before)

I do have a master's calendar but in spite of that I do not know how to do this. Does anyone have any idea?

With best regards,

Willem van der Plas

Tags (1)
1 Solution

Accepted Solutions
Contributor II

## Re: dividing customers

There are probably several ways of doing this but give something like this a shot.

CustomerClassesTemp:

CustomerId

Resident Customers;

////Creates flag for Customers with an order this month

Left Join (CustomerClassesTemp)

CustomerId,

'1' as HasOrdersThisMonthFlag

Resident OrderDetails

Where OrderDate >= MonthStart(Today());

////Creates flag for Customers with an order in a prior month

Left Join (CustomerClassesTemp)

CustomerId,

'1' as HasPastOrdersFlag

Resident OrderDetails

Where OrderDate < Date(MonthStart(Today()));

Left Join(Customers)

CustomerId,

If(HasOrdersThisMonthFlag = '1' and Isnull(HasPastOrdersFlag),'New Customer',

f(HasOrdersThisMonthFlag = '1' and HasPastOrdersFlag = '1','Loyal Customer',

if(HasPastOrdersFlag = '1' and isnull(HasOrdersThisMonthFlag),'Stopped Customer'))) as [Customer Group]

Resident CustomerClassesTemp;

Drop Table CustomerClassesTemp;

2 Replies
Contributor II

## Re: dividing customers

There are probably several ways of doing this but give something like this a shot.

CustomerClassesTemp:

CustomerId

Resident Customers;

////Creates flag for Customers with an order this month

Left Join (CustomerClassesTemp)

CustomerId,

'1' as HasOrdersThisMonthFlag

Resident OrderDetails

Where OrderDate >= MonthStart(Today());

////Creates flag for Customers with an order in a prior month

Left Join (CustomerClassesTemp)

CustomerId,

'1' as HasPastOrdersFlag

Resident OrderDetails

Where OrderDate < Date(MonthStart(Today()));

Left Join(Customers)

CustomerId,

If(HasOrdersThisMonthFlag = '1' and Isnull(HasPastOrdersFlag),'New Customer',

f(HasOrdersThisMonthFlag = '1' and HasPastOrdersFlag = '1','Loyal Customer',

if(HasPastOrdersFlag = '1' and isnull(HasOrdersThisMonthFlag),'Stopped Customer'))) as [Customer Group]

Resident CustomerClassesTemp;

Drop Table CustomerClassesTemp;

New Contributor II

## Re: dividing customers

Thankyou! It works