Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
“Aspire to Inspire before we Expire!”
ftinelli
Partner - Contributor
Partner - Contributor

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