Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

jolivares
Specialist
Specialist

Try this expression

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

Not applicable
Author

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

lironbaram
Partner - Master III
Partner - Master III

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

instead of signal put your expression

Not applicable
Author

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

jolivares
Specialist
Specialist

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