Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jade
Contributor III
Contributor III

How to Count in KPI that has no data in another sheet

Hello guys. I hope you can help with this. So, I want to identify how many organization that has no meet with a priority of 3 only. I want to display it on the KPI.  Please see the attached file. That's the sample. Thank you. 

Labels (6)
2 Replies
rubenmarin

Hi, with this script:

LOAD orgs, 
     priority
FROM
[.\sample.xlsx]
(ooxml, embedded labels, table is orgs);

LOAD orgs, 
     meet 
FROM
[.\sample.xlsx]
(ooxml, embedded labels, table is meet);

This expression may work: =Count({<priority={3}>-<meet={"*"}>} orgs)

jade
Contributor III
Contributor III
Author

Thank you, sir! It solved my problem. You're the best! 😁