topic Re: How to use bookmark together expression in QlikView

How to use bookmark together expression

Fri, 29 Jan 2016 15:14:01 GMT

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.

sunny_talwar — Fri, 29 Jan 2016 17:35:22 GMT

Try this may be:

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

HirisH_V7 — Fri, 29 Jan 2016 19:29:46 GMT

Hi ,

Look into this,

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

ftinelli — Mon, 19 Oct 2020 22:48:51 GMT

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