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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis with bookmark and modifier

Hello all,

Yet another set analysis question. I have the below expression that I want to take into account any current selections (expect month) and the BM13 bookmark, but I want it to include the specified months only. This works as long as I don't have any month selections made. If I make a month selection that doesn't include the months specified in the modifier (current quarter), the result is wrong. I want the months to always be the ones defined in the modifier regardless of month selections. All other selections and the bookmark should apply though. Where am I going wrong?

=Sum({$*BM13 <Month={'>=$(=Num(Month(QuarterStart(today()))))<=$(=Num(Month(QuarterEnd(today()))))'}>}[Sales Amount])

Any help is appreciated.

0 Replies