Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

syntax for action

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

5 Replies
avinashelite

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

Not applicable
Author

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 ...

sunny_talwar

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

Not applicable
Author

Unbenannt.PNG

what i Need is this as a Action expression:

2.PNG

settu_periasamy
Master III
Master III

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