Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey SUnny,
I can't open that qvw file, I use qvf for Qlik Sense
Try this expression
=Count({<CHAPTER = {'EC'}>} EP#)
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!
Sorry, I was not sure if there is still a question for me here?
Yes, I was wondering how I would combine these two expressions:
Count({<[UMHC SYSTEM]={'100%'}>} [UMHC SYSTEM])/16
and
Count({<CHAPTER = {'EC'}>} EP#)
May be this
Count({<[UMHC SYSTEM]={'100%'}, CHAPTER = {'EC'}>} [UMHC SYSTEM])/16
That just might work. Thank you Sunny.
You should start online classes, I'd signed up!
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.
Thanks, Bill.. I always mark when Sunny's answer is correct.