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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ddd111rgg23
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

)

    )

)

ddd111rgg23
Contributor III
Contributor III
Author

thank you