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: 
hammermill21
Creator III
Creator III

Count two different expressions

Hello,

I have to data points, one is the EP# and the other is a STANDARD. I need to count all the EP# that pertain to The STANDARD that has EC in them. 

SO I have:

STANDARD:      EP#

EC.02.01.10      EP 9

LS.02.01.10      EP 10

EC.02.01.10      EP 11

LS.02.01.10      EP 12

LS.02.01.10      EP 13

EM.02.01.10      EP 14

LS.02.01.10      EP 15

So in my last question I was shown how to count the standards that have EC in them:  Count( {<STANDARD={'EC*'}>} STANDARD) and I tried to add to it for the EP# but nothing is working. I check all the threads but didn't find anything that really worked.

Thank you

28 Replies
hammermill21
Creator III
Creator III
Author

Hey SUnny,

I can't open that qvw file, I use qvf for Qlik Sense

sunny_talwar

Try this expression

=Count({<CHAPTER = {'EC'}>} EP#)

hammermill21
Creator III
Creator III
Author

Hey, Sunny that makes sense. I think the users what to visualize something else and aren't sure how to explain it to me. But this does give me the actually total I need.

What if I need to count them then find the ones that have "EC" in them, so I would be putting these two together in a way:

I need to count: Count({<[UMHC SYSTEM]={'100%'}>} [UMHC SYSTEM])/16 then make sure that "CHAPTER" has EC in it like what you showed me before: Count({<CHAPTER = {'EC'}>} EP#)

Thank you!

sunny_talwar

Sorry, I was not sure if there is still a question for me here?

hammermill21
Creator III
Creator III
Author

Yes, I was wondering how I would combine these two expressions:

Count({<[UMHC SYSTEM]={'100%'}>} [UMHC SYSTEM])/16


and


Count({<CHAPTER = {'EC'}>} EP#)

sunny_talwar

May be this

Count({<[UMHC SYSTEM]={'100%'}, CHAPTER = {'EC'}>} [UMHC SYSTEM])/16

hammermill21
Creator III
Creator III
Author

That just might work. Thank you Sunny.

You should start online classes, I'd signed up!

Anonymous
Not applicable

Yup, Sunny is good.

If you appreciated his assistance then maybe unmark your comment as correct and mark one of his comments as correct instead and even give him a Helpful on a couple of his other comments.  He has so many points that he does not really need them, but it is nice to compliment somebody who deserves it.

hammermill21
Creator III
Creator III
Author

Thanks, Bill.. I always mark when Sunny's answer is correct.