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

[#2]

Hi All,

Any idea how i can make a search of the expression in a straight table?

I've set the expression to be searchable, now i need to put in my search string in the macro but unable to get it to work. My expression is a calculation (not a field) and not as straight forward as examples given here.

Please help. THanks.

[#3]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#4]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#5]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#6]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#7]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#8]

Hi Bertrand

There is another work around. Type ur expression in advanced search, then hit GO. Now save this as bookmark with some name. Now clear ur selections and call that bookmark id through button [ through actions ]. It will work.

Let me know once you try this.

[#9]

Hi Bertrand,

I have a need to do something similar, using a script to build the selection list - in order to exclude a value while retaining all of those that have already been selected (Toggle simply will not work for this). Any response back on iif and when they plan to allow advanced search capability?

Regards,

Calvin

[#10]

Hi Bertrand,

I have a need to do something similar, using a script to build the selection list - in order to exclude a value while retaining all of those that have already been selected (Toggle simply will not work for this). Any response back on iif and when they plan to allow advanced search capability?

Regards,

Calvin

[#11]

Hi Calvin

I think you can do it in actions. use Select in field and select the needed fields.

Then try using exclude action and exclude only that field. It will work. I have tried it.

Can you attach the qv files and source, so that i can give my try.