https://community.qlik.com/t5/App-Development/Qliksense-formula-work-only-when-filtering-in-the-lowest-level/m-p/1853906#M70505 <P>Hi, maybe it's bacause you need an aggretaion formula for aggr, like</P> <P><STRONG>Sum</STRONG><SPAN><STRONG>(</STRONG>aggr(count(enc_principal),M,case_id)<STRONG>)</STRONG></SPAN></P> <P><SPAN>Aggr returns a value for each dimension combitation, you need something to converts all those differnt values into one.</SPAN></P> Sun, 31 Oct 2021 08:15:26 GMT rubenmarin 2021-10-31T08:15:26Z https://community.qlik.com/t5/App-Development/Qliksense-formula-work-only-when-filtering-in-the-lowest-level/m-p/1853518#M70473 <P>Hello,</P> <P>With this formula, it does work well when i do filter with case_id, but when i take it of i got null</P> <P>= sum(If((m_gst&gt;=M) , principal,0))/ (aggr(count(enc_principal),M,case_id))</P> <P>&nbsp;</P> <P>Thanks</P> Fri, 29 Oct 2021 08:25:02 GMT https://community.qlik.com/t5/App-Development/Qliksense-formula-work-only-when-filtering-in-the-lowest-level/m-p/1853518#M70473 bentley32 2021-10-29T08:25:02Z https://community.qlik.com/t5/App-Development/Qliksense-formula-work-only-when-filtering-in-the-lowest-level/m-p/1853906#M70505 <P>Hi, maybe it's bacause you need an aggretaion formula for aggr, like</P> <P><STRONG>Sum</STRONG><SPAN><STRONG>(</STRONG>aggr(count(enc_principal),M,case_id)<STRONG>)</STRONG></SPAN></P> <P><SPAN>Aggr returns a value for each dimension combitation, you need something to converts all those differnt values into one.</SPAN></P> Sun, 31 Oct 2021 08:15:26 GMT https://community.qlik.com/t5/App-Development/Qliksense-formula-work-only-when-filtering-in-the-lowest-level/m-p/1853906#M70505 rubenmarin 2021-10-31T08:15:26Z