topic Re: count with a condition in QlikView

count with a condition

Tue, 06 May 2014 15:43:56 GMT

Hello,

in the "expression" tab of a pivot table, I'd like to make a count only if a condition is true, like this:

CONDITION: [QUOTA PARTECIPAZIONE DIRETTA]>'0,0' and [QUOTA PARTECIPAZIONE DIRETTA]<='0,1'

EXPRESSION: count(DISTINCT [CODICE ISTAT ENTE PARTECIPANTE])

Where I go wrong?

Thanks.

Lorenzo

Re: count with a condition

richard_pearce6 — Tue, 06 May 2014 15:46:27 GMT

Add a field into your table:

1 as RowCount

Then you can use set analysis:

sum({<[QUOTA PARTECIPAZIONE DIRETTA]={">0"}>} RowCount)

Regards

Richard

Re: count with a condition

Tue, 06 May 2014 16:12:39 GMT

Hi there,

Please check out the attached file. Its a slight variation to Richard's solution. I am using an If condition on the back-end to determine if its >0 (a Flag) so that on the front end you can just do Sum(Flag).

Hope it helps

Thanks

Re: count with a condition

maxgro — Tue, 06 May 2014 19:19:33 GMT

condition on expression?

count(distinct if([QUOTA PARTECIPAZIONE DIRETTA]>0, [CODICE ISTAT ENTE PARTECIPANTE]))

remove single quote

remove decimal or if you want it, I suppose you have to use . not , (comma)

Re: count with a condition

its_anandrjs — Tue, 06 May 2014 20:44:17 GMT

In Load script add a flag like

Load

If([QUOTA PARTECIPAZIONE DIRETTA] <= 0 ,1) as QPD_Flag

From Location;

And then in expression use expression

Count(QPD_Flag)

Re: count with a condition

Fri, 09 May 2014 08:30:14 GMT

Thanks to all for your support