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: 
dosaril
Contributor III
Contributor III

if condition

hello 

 

I'm trying to use kpi that measure sum of governance fields for which company have that name ,

but it keep show errors

 

if({<[Company Name] = {'KC'}>} , sum $(vGovernance_Maturity_Level)+ $(vCompleted_Polices_Charter)+ $(vConflict_Intrest)+ $(vDOA_Matrix)+ $(vLegal_Documentation)+ $(vDisclosure_Transparecy)+ $(vAnnual_Board_Report) / 😎

 

thank you

Labels (4)
2 Replies
Chanty4u
MVP
MVP

Try this 

Sum(

    {<[Company Name] = {'KC'}>} 

    (

        $(vGovernance_Maturity_Level) + 

        $(vCompleted_Polices_Charter) + 

        $(vConflict_Intrest) + 

        $(vDOA_Matrix) + 

        $(vLegal_Documentation) + 

        $(vDisclosure_Transparecy) + 

        $(vAnnual_Board_Report

)

    )

)

dosaril
Contributor III
Contributor III
Author

thank you