topic advanced search strings in Actions/Selections in QlikView

advanced search strings in Actions/Selections

Thu, 22 Oct 2009 19:52:11 GMT

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

advanced search strings in Actions/Selections

Thu, 22 Oct 2009 20:00:15 GMT

Bertrand you can write the macro and you can assign it to the button but again you have to know how to write the macro

Talha

advanced search strings in Actions/Selections

Thu, 22 Oct 2009 20:07:35 GMT

Hi,

thanks for your answer. That's a workaround but I would like to avoid macros for performance reasons :
Running a macro automatically deletes all caches, undo-layout buffers and undological operation buffers.

Do you have any other idea ?

advanced search strings in Actions/Selections

Thu, 22 Oct 2009 20:11:57 GMT

Well, I once asked it to a Qlikview develpor and the solution was a Macro (for the selection based on the searched values).

Here it goes the example.

advanced search strings in Actions/Selections

biester — Thu, 22 Oct 2009 20:16:22 GMT

Eager to avoid macros wherever possible, I had the same problem like Bertrand two days ago and asked support about it. The case has been escalated to second line; as soon as I have an answer I'll post it here.

Rgds,
Joachim

advanced search strings in Actions/Selections

Thu, 22 Oct 2009 20:28:12 GMT

OK,

Can you please update this post when you have the answer of the QlikTech support ?

Thanks

advanced search strings in Actions/Selections

biester — Thu, 22 Oct 2009 20:32:02 GMT

Yes, as said.

Rgds,
Joachim

advanced search strings in Actions/Selections

biester — Tue, 27 Oct 2009 13:31:30 GMT

Support suggested to work with "Toggle select". Enclosed a little demo (though I'm afraid it won't work with your case with = Sum(...) ). Anyway, as it seems "Advanced search" strings are not being supported with Select field for the time being ...

Rgds,
Joachim

advanced search strings in Actions/Selections

biester — Mon, 16 Nov 2009 19:56:10 GMT

Got the final answer from support now: advanced search strings are definitvely NOT supported in Actions/Selections

Rgds,
Joachim

advanced search strings in Actions/Selections

Mon, 16 Nov 2009 20:16:50 GMT

Too bad 🙂 !

I'll made a enhancement request :).

Thanks for your precision,

Regards

advanced search strings in Actions/Selections

Tue, 17 Nov 2009 13:42:46 GMT

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.

Re: advanced search strings in Actions/Selections

Thu, 14 Jun 2012 06:07:17 GMT

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.