Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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