Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
jskoff82
Partner - Contributor
Partner - Contributor

Can I use a variable in a "Select in field" Action on the field value?

Is is possible to use a variable in the field value of a "Select in field" action to define the field we would like to make the selection in?  The business requirement is that the field we are looking to select in may change from client to client and we are looking to push the fields into variables in the load script to make deployment as easy as possible while also minimizing the need to update the dashboard.

 

Just using 2 variables, one for the field we would like to pass into the the field value and the other to pass the field value into the Search String. 

Let vE_KPI_CLIN01_ACTION_FIELD01 = '[Stay or Visit]';
Let vE_KPI_CLIN01_ACTION_FIELD_VAL01 = 'S';

 

SelectInField.png

 

 

 

 

 

 

Have tried various permutations of Set and Let and useage of single quotes around the field name.

 

Any guidance or assistance is greatly appreciated, thanks!

2 Replies
Brett_Bleess
Former Employee
Former Employee

I believe that is likely going to result in a potential timing issue for you, so I would not recommend doing that depending upon how you are setting things etc.  If those are set on-the-fly, then it may be problematic, if you are setting those in the load script etc., then it may be ok, hopefully makes a little sense.

I thought the Help might have something, but does not appear so.  Let me try one other explanation, that might make more sense, there is no guarantee the order of the variable expressions being calculated, so if one relies upon the other, but the calculation order flips as to what you want it to be, that is where the issue is going to occur, hopefully that makes it click for you...  

Keep in mind I know enough to be somewhat dangerous with development stuff, so will be curious for one of the other MVP level folks to chime in on this one to provide their thoughts on this one, but hopefully this may help a little.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
qliksus
Specialist II
Specialist II

Maybe something like the below 

set  Variable1 = Fieldname ; 

In the field  put   ='$(Variable1)'