Apply a pre-made search string via action or macro

[peter_turner]

Hello Everyone,

I have a 'report.ini' file, with report names and filters to search my data by.
E.g
Orange Report =Fruit like 'Orange*'

I need to make a button (Action or Macro) that will apply the pre-made search string to my data, I've attached an example to show what I mean.

The idea being that I can make a large list of pre-made reports and search filters, and just add them to the report.ini file as needed.
This is similar to bookmarks, except my search string might not return any results.
If I tried to use a bookmark in this situation, it wouldn't store the raw search string I was using (as it wasn't able to make any selections).

I think i'll almost there, but not quite sure on the final stage.

Thanks,
Peter.

[#2]

Thansk Rob,

Figured that the syntax for the selection is ='=sum( { BM01 + BM02 } 1 )'

[#3]

For anyone still trying to figure this out, the following worked for me:

the field should go as text, not evaluated via a  '='

and the search expression should go as    '=Sum(money)>100e6' remember to place a = before the search string to tell qlikview to evaluate the following string....

and a heads up... if it is not working, try deleting all spaces in the search string, I don't know why but once this got a set analysis not working for me and took me hours to find out!

c ya!