Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ddd111rgg23
Contributor III
Contributor III

data didn't show in KPI

Hello 

i face an issue with some KPI's in sheet , some of them not shows any values 

 

dosaril_0-1723359173807.png

the formula i used in GA,BoD, Meetings:

sum({<Flag = {'Governance'},[KPI Name] = {'GA, BoD, Committees meetings'}>}Actual)
/
sum({<Flag = {'Governance'},[KPI Name] = {'GA, BoD, Committees meetings'}>}Plan)

Thank You 

Labels (4)
3 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

try this:

sum({<Flag = {'Governance'},[KPI Name] = {'GA','BoD','Committees meetings'}>}Actual)
/
sum({<Flag = {'Governance'},[KPI Name] ={'GA','BoD','Committees meetings'}>}Plan)

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

by the way -  if my original suggestion does not work then it is something with your data or data model.

 

cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
ddd111rgg23
Contributor III
Contributor III
Author

thank you