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

Question about set analysis

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!

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({BM<SpecialField = $::SpecialField>} field)

or

Sum({BM<SpecialField = p(SpecialField)>} field)

View solution in original post

3 Replies
sunny_talwar

May be this

SUM({$*BM} field)

josecanalla
Creator
Creator
Author

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...

sunny_talwar

May be this

Sum({BM<SpecialField = $::SpecialField>} field)

or

Sum({BM<SpecialField = p(SpecialField)>} field)