Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmarinesc
Contributor III
Contributor III

Count expression for diff fields...

 
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.

ESremisionESNOMATCHESNOMATCH1ESNOMATCH2
37
76-1
77-1-1
155-1-1
167-1-1
174-1-1-1
228-1-1-1
321-1 -1
387-1 -1
Count = 9

JMC

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
MayilVahanan

HI

Try like this

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

or

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

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

With these conditions you will get only 2

Expression

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

jmarinesc
Contributor III
Contributor III
Author

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

HI

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jmarinesc
Contributor III
Contributor III
Author

Great!

Expr OK

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

  • Mayil.....IF I need Count like:

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

I get: Error in set modifier expr

JMC

MayilVahanan

HI

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.