topic Count (Sub Total) in QlikView

Count (Sub Total)

Fri, 17 Jul 2009 01:07:35 GMT

Is it possible to do a count(sub total)?

For instance,

ID1 ID2 Count

a 1 4

a 2 4

a 3 4

a 4 4

b 5 3

b 6 3

b 7 3

For the IDs, I want to to a subtotal of how many ID2 are in ID1.

Count (Sub Total)

Fri, 17 Jul 2009 01:21:34 GMT

Are you looking to do it in your load script or as an expression in your app?

In the load script, I would probably use a sub-query. You would need to group by ID1 and do a Count of ID2. It doesn't really work to do that out of an Inline, but it should work on a Database or Table File.

To do it in an expression, I would use:

Aggr(NODISTINCT Count(DISTINCT ID2), ID1)

I've attached a sample.

Count (Sub Total)

Fri, 17 Jul 2009 01:23:35 GMT

In a chart expression. I actually just figured it out. Count(DISTINCT TOTAL <ID1> ID2) gave the what I needed. Thanks for the reply.