A measure evaluting/counting another measure

[Thomas_Qlik]

I have a key (e.g. AN) that consists out of several attributes (e.g. AN-WERT2, AN-XW2JA), which each have a value (e.g. 0, Yes).

What I would like to do is to compare for each attribute the AS IS values against certain predefined TO BE values. I have written a measure m_P2P09_Attribute_Compliant, which compares the two tables holding the AS IS and TO BE values with each other.

As a second step –and here I get stuck- I want to assess for each key whether it is compliant. Meaning: All the attributes of this key are compliant (Measure m_P2P09_Attribute_Compliant=”Yes”). If a key has one or more attributes with “No” it would not be compliant.

I thought I could do this assessment with another Measure: m_P2P09_Key_Compliant, which would deliver back “Yes” or “No”.

Can anybody please help me out how the logic of the Measure m_P2P09_Key_Compliant measure would look like?

Much appreciated,

Thomas

[G3S]

instead of yes/no maybe try 1/0 then  sum by Key_TOBE. based on output being certain values, bring in yes/no ?

[Thomas_Qlik · Accepted solution]

the suggestion from G3S unfortunately did not do the trick. At the end I got lucky using the aggr function.

if(
COUNT(aggr(if([m_P2P09_Attribute_Compliant]='No',1),[ID_ASIS-ID_TOBE]))=0,"Yes","No"
)