advanced search strings in Actions/Selections

[#1]

Hi,

As you may know, in QlikView search text boxes you can use advanced expressions.

For example if I've two fields : "Customers" and "Sales". If I create a listbox for the field "Customers" and I make a search on it : I put the expression =Sum(Sales)>1000. QlikView will select Customers which made more than 1000 of sales.

That's very usefull and powerfull ... for advanced users who knows how to write expressions. So to simplify it for other users. I would like to create a button which execute the selection.

But I can't find how to do it : when I create a button, I open the properties, "Actions" Tab, Add Action, select in field. In "Field", I write Customer. In search String, I write =sum(Sales)>1000. the button doesn't do anything.

Is there a syntax problem or do you know how to workaround it ?

Thanks

P.S : I'm working with QlikView Desktop V9 SR1

[arieidel]

Maybe it is a little late and you might have resolved this issue. Anyway, I'm here to tell you that it worked for me to trigger an Advanced Search.

In Search String expression you should type:

='your_advanced_Search'

For example:

='=SUM({$<[Status]={"OK"}>} Item)>0'

Hope it helps!

Ariel