topic Re: Count distinct Customers in QlikView

Count distinct Customers

Sat, 27 Jul 2013 04:10:03 GMT

In the Excel file the data is:

Customer

TypeDoc

Date

In 2 controls I select 2 dates: Initial date and Final date

I need to count how many different customers there are between the dates, and TypeDoc = 'TA'

Example:

Initial Date: May 02, 2012 <-- In variable VarDate1

Final Date: May 31, 2012 <-- In variable VarDate2

TypeDoc = 'TA'

The answer is 46 customers, but I can't create a aggr expresion that show it.

I have this but don't works:

Count(DISTINCT aggr(If(Date >= $(VarDate1) and Date <= $(Vardate2) and TypeDoc= 'TA',Customer), Customer))

Thanks.

jagan — Sat, 27 Jul 2013 05:16:12 GMT

Hi,

Please find attached file for solution. I used this expression

=Count({<CustomerDate={'>=$(=VarDate1)<=$(=VarDate2)'}, TypeDoc= {'TA'}>} DISTINCT Customer)

VarDate1 = MakeDate(2012, 5, 2)

VarDate2 = MakeDate(2012, 5, 31)

Regards,

Jagan.

Sat, 27 Jul 2013 05:42:14 GMT

Thanks.!!.

jagan — Sat, 27 Jul 2013 07:14:20 GMT

HI,

Please close the discussion by clicking Correct Answer button to my post if it solves your purpose, it helps others to find the answer.

Regards,

Jagan.