Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

Formula syntax check

Hi, 

Could anyone help checking this measure? Appears to be correct, but it is not returning any values.

If([APSYS.Site]='D&IS UK', Avg({<[APSYS.APSYS_Sub_Item]={'Global'},
[APSYS.APSYS_Result_Level]={'Domain Level'}>}[APSYS.APSYS_Score]))

Many thanks

Jose

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Incorporate all conditions inside the set

=Avg({<[APSYS.Site]={'D&IS UK'}

,[APSYS.APSYS_Sub_Item]={'Global'}
,[APSYS.APSYS_Result_Level]={'Domain Level'}>

}[APSYS.APSYS_Score])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Incorporate all conditions inside the set

=Avg({<[APSYS.Site]={'D&IS UK'}

,[APSYS.APSYS_Sub_Item]={'Global'}
,[APSYS.APSYS_Result_Level]={'Domain Level'}>

}[APSYS.APSYS_Score])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
JoseGarcia
Creator III
Creator III
Author

Thanks a million! Spot on! 
Worked great!