topic Create a button to set fields to selected values of other fields in App Development

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

kge01 — Thu, 29 Dec 2022 14:20:18 GMT

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!

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

JHuis — Thu, 29 Dec 2022 13:17:13 GMT

Is one button with multiple actions not better?

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

kge01 — Thu, 29 Dec 2022 13:24:12 GMT

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.

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

JHuis — Thu, 29 Dec 2022 13:46:33 GMT

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.

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

kge01 — Thu, 29 Dec 2022 14:22:04 GMT

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

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

kge01 — Wed, 04 Jan 2023 10:11:46 GMT

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

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

jbhappysocks — Wed, 04 Jan 2023 14:38:44 GMT

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.

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

kge01 — Wed, 04 Jan 2023 15:00:39 GMT

Thanks you very much, that was it!

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

kge01 — Fri, 27 Jan 2023 17:51:10 GMT

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!

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

fedoti5061 — Sat, 28 Jan 2023 09:29:15 GMT

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-

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

jbhappysocks — Mon, 30 Jan 2023 08:58:23 GMT

Sorry, I don't think you can do this without first removing the " from you "Hello"

To change the string to remove the double "" you move the replce() outside of the expression, like:

=replace(

'('&'"'& GetFieldSelections(ref_name,'"|"', GetSelectedCount(ref_name, True())) &'"'&')'

,'""', '"' )

But if you do this the selection will not be correct as Qlik will try to Select Hello, not "Hello".

I doubt you can get around this, but if anyone has an idea I would also love to see it.