Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Got the final answer from support now: advanced search strings are definitvely NOT supported in Actions/Selections
Rgds,
Joachim
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
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 ?
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.
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
OK,
Can you please update this post when you have the answer of the QlikTech support ?
Thanks
Yes, as said.
Rgds,
Joachim
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
Got the final answer from support now: advanced search strings are definitvely NOT supported in Actions/Selections
Rgds,
Joachim
Too bad 🙂 !
I'll made a enhancement request :).
Thanks for your precision,
Regards