Count occurences of values

[#1]

Hello Qlikview Developers,

I've got a little problem trying to count occurences of a formular result - this is my table:

Supplier	avg. delivery time
Sup1	10
Sup2	12
Sup3	12
Sup4	12
Sup5	18
Sup6	18

Result should look something like this:

avg. delivery time	occurences
10	1
12	3
18	2

I don't know how to get a grip on that, especially if there should be the possibility to drilldown to the suppliers... Any Ideas?

Thanks in advance...

[tresesco]

Straight table:

Dim: [avg.delivery time]

Exp: Count([avg.delivery time])

[kaushiknsolanki]

Hi,

All you need to do is create a straight table and keep Delivery Time as Dimension and

Count(Delivery time) as Expression.

Regards,

Kaushik Solanki

[#4]

The avg. delivery time is based on a formular - avg(deliverydate-expecteddeliverydate) -> When I'll try to put that into a dimension I just got '//Failure in Dimension'.

[kaushiknsolanki · Accepted solution]

Hi,

Try this dimension.

Aggr(avg(deliverydate-expecteddeliverydate) ,Supplier)

Count(Aggr(avg(deliverydate-expecteddeliverydate) ,Supplier))

Regards,

Kaushik Solanki