Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this may be:
Sum({BM01}+$< IdCompanies={'2013'}>} Sales)
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
Sum({"BM01"<IdCompanies={'2013'}>} Sales)