Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
dosaril
Contributor II
Contributor II

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.
dosaril
Contributor II
Contributor II
Author

thank you