topic Re: How to get customer count based on range of dates? in QlikView

How to get customer count based on range of dates?

Thu, 18 Sep 2014 11:06:40 GMT

Hi,

I have fields Owner, CustomerId, EnterDate. Based on this EnterDate I need to calculate count(CustomerId)

I,e

Dimension: Owner

Expression: Count(CustomerId) when EnterDate between last monday to current Monday I,e from 08/09/2014 to 15/09/2014

Can anyone please help me with expression. As I can see this with selection of list box but user don't want to select in list box.

Thanks.

MK_QSL — Thu, 18 Sep 2014 11:22:08 GMT

=SUM({<[Invoice Date] = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}Amount)

1) Change FieldName Accordingly

2) Also, if instead of Today(), you want Previous Week Monday to Selected Date Monday,

Replace Today() with Max([Invoice Date])

Thu, 18 Sep 2014 11:26:32 GMT

try this

=count({<EnterDate = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}CustomerId)

MK_QSL — Thu, 18 Sep 2014 11:28:55 GMT

I have used SUM(Amout).... as Vishwaranjan said, you can change as COUNT(CustomerID)

Thu, 18 Sep 2014 11:30:28 GMT

Thanks.

Thu, 18 Sep 2014 11:30:35 GMT

Thanks

Thu, 18 Sep 2014 11:33:33 GMT

How can I change the same expression if I want to include the same condition but with

CustomerStatus='Fail1'

Please help

MK_QSL — Thu, 18 Sep 2014 11:36:15 GMT

=COUNT({<CustomerStatus = {'Fail1'},[Invoice Date] = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}CustomerId)

Thu, 18 Sep 2014 11:39:09 GMT

Great Thanks.