topic Re: Count expression with if in QlikView

Count expression with if

Mon, 27 Jan 2014 21:09:11 GMT

Hy guys!

I need a help to resolve a little problem with my count expression...

i have a field (Numbers of interventions) and i need to count this field only if the sum of hours of interventions are > 20.

I try to do the expression...but it doesn't work...

sum(if(sum(aggr(sum(VAL_SKP), COD_PDR))>20,1,0))

Thank you for help!!!!

Re: Count expression with if

swuehl — Mon, 27 Jan 2014 21:17:36 GMT

Maybe like

=sum( aggr( if( sum(VAL_SKP) > 20, 1,0), COD_PDR))

but I am pretty unsure what you need here. Could you upload a small sample application?

Re: Count expression with if

rustyfishbones — Mon, 27 Jan 2014 21:21:07 GMT

You could try

SUM({<VAL_SKP ={">20"}>}COD_PDR)

Re: Re: Count expression with if

Mon, 27 Jan 2014 21:37:35 GMT

i have a table like the first two column...

the point is that i need to sum 1 only if is verified the condition sum(aggr(sum(val_skp),cod_pdr))>20...if this condition is ok then i sum 1, else 0. condition works well but the "then" instruction doesn't work. it is because there are sum operator outside and inside if instructions. Have u got some suggestions?

thx a lot

COD_PDR	VAL_SKP	SUM(ORE_PDR_INTER)
		60,54
31761701	0,38	0,76
34112001	0,5	2
31952801	0,54	1,08
31952802	0,54	1,08
32317701	1,54	3,08
34651403	1,54	3,08
31716701	0,42	0,84
34636601	0,42	0,84
35720301	1,67	6,68
34299101	0,54	1,08
34335102	0,54	1,08
33040301	1,54	3,08
50034301	1,54	3,08
50037201	1,54	3,08
33022401	0,54	1,08
31290401	0,27	0,54
31290402	0,27	0,54
34561402	0,27	0,54
34572602	0,27	0,54
34572902	0,27	0,54
34573505	0,27	0,54
32708501	0,5	1