carry over the values

[louise119]

Hi,
I want to carry over the values selected in the data_carry sheet to another sheet data_carry2 using button below.
These sheets refer to data from another DB, but how can I make Japan selected in green in the data_carry2 sheet?

Please help.....

  

  

Thank you.

[pensa-qlik]

Hello,

Have you tried using the GetFieldSelections() function. In the action pane of your button, you can select ' Select Values in a field', set the field as 'RegionX' and set the value to =GetFieldSelections(Region). 

Hope this helps!

[Prem0212]

Its working for me with Getfieldselections function in action option of a Button

[louise119]

I tried  GetFieldSelections() function. but in my case, the filter has the if statement and the filed of another sheet has if statement as well.
So I used the  GetFieldSelections() function like below.
But it doesn't work .....

【Formula】

・the field：RegionX
・the value：GetFieldSelections("If(~~~~~~)") 

[pensa-qlik]

Can you explain what you're doing with the if statement or provide more details from the formula?

[louise119]

I am using an if statement in my filter to only show data for some countries.
I wanna transfer the data I selected in sheet A to sheet B automatically when I open the sheet B.

sheet A：

The formula for the filter is below.
-> if(Region="US" or "UK",Region)

sheetB：

The formula for the filter is below.
-> if(RegionX="US" or "UK" or "Korea" or "China",RegionX)