topic Count First Sorted Value in QlikView

Count First Sorted Value

Tue, 22 Apr 2014 06:48:28 GMT

Hi,

I have this initial situation (Attachment below)

Per Customer (third column "Kunde") I have several Actiontypes (Column "Aktionstyp") with the Date (Column "Datum").

What I want is to count the Customers with the first ActionType. In the attachment the first Action Type for the Customer 640068 is "2 - Telefonat", for the Customer 640069 "6 - Besuch"

The result should look like this:

Action Type Count Customers

2 - Telefonat 1

6 - Besuch 1

How can I count the customers per first Action Type?

Thanks in advance

Re: Count First Sorted Value

arjunkrishnan — Tue, 22 Apr 2014 06:56:53 GMT

Let Pls Attach Ur Xls or Qwv ...Thats Useful to Workout as

Re: Count First Sorted Value

mdmukramali — Tue, 22 Apr 2014 06:56:54 GMT

Dear,

if your using Action Type as dimension then directly you can use count(Customers).

if you need something else can you attach the sample file.

Thanks,

Re: Count First Sorted Value

Tue, 22 Apr 2014 07:31:19 GMT

Okay, here is the QVW.

I have selected two customers, but the result should capture all customers.

@Mohammed: Yes, I want to use "Action Type" as dimension, but there are many Action Types for ONE customer, I only want to see the Action Type with the min date, the first date.