Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

Count in a pivot table

Hello everiboy! I need count rows that the signal is 'YES'. An example:

NroPedido  Signal   Result

1                    SI       3

2                    SI       3

3                    NO     3

4                    SI       3

The signal is an expresion too.

The result for this will be three.

Thank you!!

6 Replies
Not applicable

Re: Count in a pivot table

Count({<Singal={'YES'}>}NroPedido)

jolivares
Valued Contributor

Re: Count in a pivot table

Try this expression

Count(TOTAL {<Signal={'SI'}>} NroPedido)

Not applicable

Re: Count in a pivot table

This expresion dont work,  the problem is that in my case Signal is not a dimension is an expresion.

lironbaram
Honored Contributor II

Re: Count in a pivot table

count (aggr(if(SIgnal='SI',NroPedido),NroPedido))

instead of signal put your expression

Not applicable

Re: Count in a pivot table

It dont work, The expresion Signal have another expresion inside , this expresion have an other inside .. repeatedly

jolivares
Valued Contributor

Re: Count in a pivot table

Try to post a complete example of what really you want.

Community Browser