topic Re: syntax for action in QlikView

syntax for action

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like to add an action, which helps to choose the searchwords i want with conditions as the expression for the searching string, like in sql:

select* from xy where fieldname="blabla"

can somebody help me please?

It sounds easy but i cannot convert it. There is no problem to add it in the script but i need it for the Action

Re: syntax for action

avinashelite — Tue, 12 Apr 2016 11:53:40 GMT

Did not get the exact requirement , you could try like this .

Create a variable to capture the text that need to be passed for the script and you could use the variable in the where condition

Let vcontent="User_defined_text";

select* from xy where fieldname=$(vcontent);

you could change the variable value in the front end too , just add a input box and assign this variable for that

Re: syntax for action

Tue, 12 Apr 2016 12:12:07 GMT

i also tried this, but there is the same Problem. i have to put a condition (like where) which chooses * . but in the Expression (for Action) I cannot use WHERE ...

Re: syntax for action

sunny_talwar — Tue, 12 Apr 2016 12:13:53 GMT

Is this a front end thing you are looking for or back end (script) based thing?

Re: syntax for action

Tue, 12 Apr 2016 12:17:00 GMT

what i Need is this as a Action expression:

Re: syntax for action

settu_periasamy — Tue, 12 Apr 2016 13:52:42 GMT

May be refer your thread action-syntax for searching string like sql