Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
peter_turner
Partner - Specialist
Partner - Specialist

Apply a pre-made search string via action or macro

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.

11 Replies
Not applicable

Thansk Rob,

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

Not applicable

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

Capture.PNG

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!