topic Re: Count expression for diff fields... in QlikView

Count expression for diff fields...

jmarinesc — Mon, 03 Dec 2012 23:25:46 GMT

 
 Hello QVComm....

I am using below expression :

COUNT({<ESNOMATCH={'-1'},ESNOMATCH1={'-1'},ESNOMATCH2={'-1'}>} ESremision)

Using Expr in Pivot Table, How can I Count ESremision (9) with these conditions.........Tk in advanced.

JMC

MayilVahanan — Mon, 03 Dec 2012 23:36:41 GMT

Try like this

=Sum(Aggr(1,ESremision)) in title/ caption

In expression, rowno() and in expression tab, change the total mode as numeric count of rows in dropdown list

hope it helps

CELAMBARASAN — Mon, 03 Dec 2012 23:37:15 GMT

With these conditions you will get only 2

Expression

COUNT({<ESNOMATCH={-1},ESNOMATCH1={-1},ESNOMATCH2={-1}>} ESremision)

jmarinesc — Tue, 04 Dec 2012 16:20:24 GMT

Hello!

I try this expr....and I get : Error in set modifier ad hoc element list.....

count({<ESNOMATCH={-1}>+<ESNOMATCH1={-1}>+<ESNOMATCH2={-1}>} ESremision)

JMC

MayilVahanan — Tue, 04 Dec 2012 16:27:51 GMT

Try like this

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1={'-1'}>+<ESNOMATCH2={'-1'}>} ESremision)

jmarinesc — Tue, 04 Dec 2012 16:33:31 GMT

Great!

Expr OK

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1={'-1'}>+<ESNOMATCH2={'-1'}>} ESremision)

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1<>{'-1'}>+<ESNOMATCH2<>{'-1'}>} ESremision)

I get: Error in set modifier expr

JMC

MayilVahanan — Tue, 04 Dec 2012 16:42:39 GMT

Try like this

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1-={'-1'}>+<ESNOMATCH2-={'-1'}>} ESremision)