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

How to use bookmark together expression

Hi,

May I use a bookmart together another expression in QV?

For example:

Sum({BM01}, IdCompanies={'2013'} Sales)

the thappend is i need to filter data applying another condition withot the bookmark name.

3 Replies
sunny_talwar

Try this may be:

Sum({BM01}+$< IdCompanies={'2013'}>} Sales)

HirisH_V7
Master
Master

Hi ,


Look into this,

How to Create QlikView Bookmark Filters Using Dynamic Search Expressions

set_identifier ::= 1 | $ | $N | $_N | bookmark_id | bookmark_name

  =Sum({$*BM01}+$< IdCompanies={'2013'}>} Sales)


sum({$*BM01} Sales)

returns sales for the intersection between the current selection

and bookmark BM01.

sum({-($+BM01)} Sales)

returns sales excluded by current selection and bookmark

BM01.


-Hirish


HirisH
ftinelli
Partner - Contributor
Partner - Contributor

Sum({"BM01"<IdCompanies={'2013'}>} Sales)