Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is't possible to create and save a indirect(select all except...) bookmark?
I have a selection of all retails chains except one. The problem is next time i use the bookmark a new chain has been added to the database. So if am not careful i will miss this new chain when i use the old bookmark, and i must create a new bookmark och delete the old one.
Ideas to handel this?
For text you have to use single quotes.
This
=not match(Kedja, 'InternKund')
Or this:
=not match([Kedja], 'InternKund')
Hi,
It's not hard to do. Download data, select what you want to exclude. Call it for example Bookmark1. Further in the diagram, we exclude this selection.
For example,
Sum({1-Bookmark1}Value)
Look attached file. If in script code change "Autogenerate 10" to "Autogenerate 20", Exception value ID=4 will remain.
Regards,
Andrey
You should be able to enter an expression in your search field and make that your book mark.
You could do something like
=not match(ID,2,3)
This would filter to all ID numbers that are not 2 or 3.
Create a bookmark on that and it will automatically include any new ID numbers.
Hi,
Are you sure? Tried this:
=not match(Kedja, InternKund)
and
But didn't work
instead you can use trigger to select all excluding 1 value
For text you have to use single quotes.
This
=not match(Kedja, 'InternKund')
Or this:
=not match([Kedja], 'InternKund')