Qliksense : formula work only when filtering in the lowest level

[bentley32]

Hello,

With this formula, it does work well when i do filter with case_id, but when i take it of i got null

= sum(If((m_gst>=M) , principal,0))/ (aggr(count(enc_principal),M,case_id))

Thanks

[rubenmarin]

Hi, maybe it's bacause you need an aggretaion formula for aggr, like

Sum(aggr(count(enc_principal),M,case_id))

Aggr returns a value for each dimension combitation, you need something to converts all those differnt values into one.