Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

May be this

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

or

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

View solution in original post

3 Replies
sunny_talwar
MVP
MVP

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

May be this

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

or

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