topic Re: Count values (>1) in Pivot Table in QlikView

Count values (>1) in Pivot Table

Thu, 13 Mar 2014 18:21:04 GMT

Hello, I have the following Pivot Table:

What I need is to count in the field # Atenciones (it's an expression) those values > 1 (without expansion)...

But the thing is that if I expand the field Cuenta, I could have 2 & 1 # Atenciones (3 in total).

How could I do that?

Thank you!!

giakoum — Thu, 13 Mar 2014 18:23:37 GMT

you need to use the aggr function.

aggr(count(# Atenciones), Categoria, cuenta)

Thu, 13 Mar 2014 18:28:55 GMT

And how do I count if those values are >1 using that function? Thanks!

its_anandrjs — Thu, 13 Mar 2014 19:38:35 GMT

Hi,

Count the frequency in the load script and use it in expression.

Hope this helps

Thanks & Regards

giakoum — Thu, 13 Mar 2014 19:43:17 GMT

if(aggr(count(# Atenciones), Categoria, cuenta) > 1, 'do something', 'do something else')

Tue, 18 Mar 2014 10:37:48 GMT

Hi Sam,

Use expression

=if(Count(TOTAL #Atenciones)>1,Count(TOTAL #Atenciones)

This may help..