Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am working with set analysis in Qlik sense.
I have this expression: SUM({BM} field) where BM is a bookmark.
This expression is not modified if I do any selections in the app. I want that the expression will modify if I do selections in only one special field of the app... how can I do this?
Thanks!
May be this
Sum({BM<SpecialField = $::SpecialField>} field)
or
Sum({BM<SpecialField = p(SpecialField)>} field)
May be this
SUM({$*BM} field)
No, that modifies the expression if I select anything in the app. I want to modify the expression only if I have selections in special field...
May be this
Sum({BM<SpecialField = $::SpecialField>} field)
or
Sum({BM<SpecialField = p(SpecialField)>} field)