Create a button to set fields to selected values of other fields

[kge01]

Hey!

I need to create a button that sets multiple fields to the selected values of multiple other filters.

I created a test qvf as an example (see file attached):

What this button should do is:

• Set “name” to the selected values of “ref_name”
• Set “number” to the selected values of “ref_number”
• Set “date” to the selected values of “ref_date”

I figured out to create 3 buttons which work to my satisfaction (see buttons: “set name to ref_name”, “set number to ref_number”, “set date to ref_date”).

However, I need to create one single button that performs all the 3 actions above, so you don't need to click on 3 different buttons. I tried to do this, but it doesn’t work (see button “set name to ref_name + set number to ref_number + set date to ref_date”).

Any ideas how to solve this?

Thank you very much for your help!

[JHuis]

Is one button with multiple actions not better?

[kge01]

Yes, that's what I'm trying to do. I created the button “set name to ref_name + set number to ref_number + set date to ref_date” that includes all the 3 actions. But it doesn't work.

[JHuis]

Dear KGE,

but i dont know what you are trying to archieve.  Because you have to make selections to make a selection in a field. 

I am not seeing what you want to do. 

[kge01]

I need to do this, because our users need to compare results for different datasets. They want to choose filters for dataset1 and dataset2  and see how the results differ (by the way, I don't/can't use alternate states for that, because an extention I need doesn't support them)

Very often the needed filters for dataset1 and dataset2 are very similar, the users only need to change 1 or 2 filters. Because of that they want a button to transfer the selections from dataset1 to dataset2 (so for dataset2 they can click on the button to transfer the selections for dataset1 to dataset2 and then only need to set the 1 or 2 filters for dataset2 that should be different from dataset1).

[kge01]

Hi! Is there a possibility to create such button, or is it not possible with Qlik?

[jbhappysocks · Accepted solution]

Hi. If you just change the action from Select values in a field to Select values matching search criteria for number and date (You already have it for name) the button in your testfile works.

[kge01]

Thanks you very much, that was it!

[kge01]

Thank you again for your help! I just stumbled across another issue...

If the string in the field has quotations, the selections are not made.

The formula seems not to be interpreted correctly. I tried replacing the double quotations with two double quotations (as an escape character), but that didn’t work either.

Btw I'm facing the same issues if there are single quotes (at the beginning of) the string.

Again, to show the issue, I added an example file.

Do you have any ideas on how to solve this? Thank you!

[fedoti5061]

I am having a hard time figuring it out. Just FYI, these buttons are not in the form but the field I need to update is in the form.publixsurvey-