topic Re: GetFieldSelections() - Transfer the selection from one column to another with a button in QlikView

GetFieldSelections() - Transfer the selection from one column to another with a button

Wed, 25 Nov 2020 16:16:04 GMT

GetFieldSelections() - Transfer the selection from one column to another with a button

I'm trying to transfer the selection from one column to another with a button (when I can not link them directly in the script), using the GetFieldSelections() function.

However, I've found problems because in the selection appears arguments instead of data (apparently it uses the current selections of data).

TAB_NAME:

LOAD * INLINE [

NAME, ID

JOSE DA SILVA, 1

ALVARO CABRAL, 2

MARIO SERGIO, 3

RODRIGO ALVES, 4

EDUARDO CUNHA, 5

CHICO BUARQUE, 6

EMILIA BONECA, 7

SACI PERERE, 8

JUCA KIFURI, 9

JAMIL EUMANOITE, 10

JACA PODRE, 11

];

TAB_ALIAS:

LOAD * INLINE [

ALIAS, ID2

JANAINA CORDEIRO, 1

JUCELIA SILVA, 2

NILZA APARECIDA, 3

AMARAL DO PALMEIRAS, 4

JULIO CESAR, 5

JANIO QUADROS, 6

EMILIA BONECA, 7

SACI PERERE, 8

ALVARO CABRAL, 9

EDUARDO CUNHA, 10

MARIO SERGIO, 11

RODRIGO ALVES, 12

JOSE DA SILVA, 13

CHICO BUARQUE, 14

];

When selecting some records NAME, and click the button, the values are transferred to ALIAS, as desired, using the GetFieldSelections() function.

But, when selecting many or all records, the GetFieldSelections() function returns "ALL" and nothing is useful to select ALIAS.

When selecting 8 records NAME, NOT appears and the selection by GetFieldSelections () for the ALIAS is what you do not want.

So, does anyone know another way to get exactly the list of selected data in a particular field to apply on another field?

Thanks in advance!

Re: GetFieldSelections() - Transfer the selection from one column to another with a button

kaushiknsolanki — Mon, 07 Nov 2016 17:31:31 GMT

Hi,

Try this in Field Selection Search String.

='("'&Concat(NAME,'"|"')&'")'

Regards,

Kaushik Solanki

Re: GetFieldSelections() - Transfer the selection from one column to another with a button

jcampbell474 — Mon, 07 Nov 2016 18:31:37 GMT

You can try: Document Properties > Triggers > Field Event Triggers > Select the initial field in Field Event Triggers, then On Select and OnChange > Action Type: Selection > Action: Select in Field.

I've used this feature to link one selection at a time. Not sure if it will work with >1 selections...

Re: GetFieldSelections() - Transfer the selection from one column to another with a button

Mon, 07 Nov 2016 18:31:49 GMT

Excellent!

Thanks!

Re: GetFieldSelections() - Transfer the selection from one column to another with a button

Mon, 07 Nov 2016 18:41:35 GMT

I was looking for a user decision way.

I think a trigger will not apply in this case.

By the way, Kaushik Solanki gave me a Concat() method that work's fine!

Thank's anyway.