Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-12-10 05:14 AM

Categorise customer based on consecutive months sales.

Criteria.

If Customer has a sales value > 0 in each of the last 3 months set to A.

If Customer has a sales value > 0 in each of the last 6 months set to B.

If Customer has a sales value > 0 in each of the last 9 months set to C.

I'm open to any ideas to classify this?

I'm thinking I need to do this as part of the load and assess 'InMonthtoDate' into a summarised table somehow.

Regards,

Steve

120 Views
0 Likes
0 Replies