Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Customer count by month

Hi,

I'm trying to create a bar chart showing the number of active customers for the current month and 6 months back. Customers have a StartDate and a EndDate. How to configure the date range as a dimension is what I'm struggling with. Any pointers or hints would be much appreciated!

Thanks!

1 Solution

Accepted Solutions
Not applicable

Re: Customer count by month

I belive I got it working with help from this post: http://www.qlikcommunity.com/thread/56715

Added this in my load script:

AddMonths(MonthStart(StartDate),iterno()-1) as ContractMonth

While MonthStart(EndDate) >= AddMonths(MonthStart(StartDate),iterno()-1);

Added a car chart with ContractMonth as dimension and the following expression:

Count({<Company = {'24'}, Status = {A}>} CustomerNo)

The active contracts are listed sorted by month as per 1st of the given month, however some contracts have fictitious dates set to a year we will all be gone. So one of the month groups displayed is for active contract in the year 2099.

I got help on how to filter this in this thread: http://community.qlik.com/message/272886#272886

Message was edited by: tfolgero

2 Replies
jason_michaelid
Honored Contributor II

Re: Customer count by month

So you have Date as a field as well as StartDate and EndDate?

Not applicable

Re: Customer count by month

I belive I got it working with help from this post: http://www.qlikcommunity.com/thread/56715

Added this in my load script:

AddMonths(MonthStart(StartDate),iterno()-1) as ContractMonth

While MonthStart(EndDate) >= AddMonths(MonthStart(StartDate),iterno()-1);

Added a car chart with ContractMonth as dimension and the following expression:

Count({<Company = {'24'}, Status = {A}>} CustomerNo)

The active contracts are listed sorted by month as per 1st of the given month, however some contracts have fictitious dates set to a year we will all be gone. So one of the month groups displayed is for active contract in the year 2099.

I got help on how to filter this in this thread: http://community.qlik.com/message/272886#272886

Message was edited by: tfolgero

Community Browser