topic Re: getfieldselection into variable not working in QlikView

getfieldselection into variable not working

qlikviewuser20 — Thu, 11 Mar 2021 09:30:54 GMT

Hi,

I have a strange behaviour of the GetfieldSelection function.

I have a field loaded into the script with AUTOGENERATE :

Annee_Test:
LOAD
$(vAnneeMin) + rowno()-1 as _Annee_Test
AUTOGENERATE $(vAnneeMax) - $(vAnneeMin) + 1;

In the application , i added a trigger onselect on the field _Annee_test and define a variable vAnneeTest: =GetFieldSelections(_Annee_Test)

Than i have a listbox with _Annee_Test and when i display the variable vAnneeTest it takes the value of _Annee_Test but when i choose the max year or the max year-1 it stuck on the last selected value:

Re: getfieldselection into variable not working

Or — Thu, 11 Mar 2021 10:06:40 GMT

I had a bit of trouble following along:

1) Your field appears to be Annee_Test, not _Annee_Test (with a leading underscore)

2) Why did you add a trigger? What does the trigger do?

Re: getfieldselection into variable not working

qlikviewuser20 — Thu, 11 Mar 2021 11:03:23 GMT

1 ) it's _Annee_Test ? I just change the label in the listbox

2) I added a trigger on select to get the value of _Annee_Test into the variable vAnneeTest (Same result if i just declare the variable as =getfieldSlections(_Annee_Test)

Re: getfieldselection into variable not working

Or — Thu, 11 Mar 2021 11:09:01 GMT

1) OK - obviously, there was no way to know that based on the image, so had to make sure that wasn't the issue

2) I'm not sure why you're doing it with a trigger instead of using a regular variable. OnSelect triggers are known to be somewhat wonky, particularly in the ajax client (for example, https://community.qlik.com/t5/QlikView-App-Dev/Onselect-Trigger-not-firing-when-selected-through-a-button/m-p/1435039 ) - are you able to use OnChange instead? If so, does that work as expected?

Re: getfieldselection into variable not working

qlikviewuser20 — Thu, 11 Mar 2021 11:53:40 GMT

same thing with OnChange

Re: getfieldselection into variable not working

Or — Thu, 11 Mar 2021 12:18:55 GMT

I've attempted to test this locally and it works fine on my end, no matter which selections I make (QV 12.5 SR3).

You could try using a value of =_Annee_Test (instead of GetFieldSelections) and see if that works - obviously it'll only work for one year but it's worth testing out. You could also try with Concat(distinct Year,';').

Re: getfieldselection into variable not working

Or — Thu, 11 Mar 2021 12:18:57 GMT

I've attempted to test this locally and it works fine on my end, no matter which selections I make (QV 12.5 SR3).

Re: getfieldselection into variable not working

qlikviewuser20 — Thu, 11 Mar 2021 14:29:02 GMT

it is really weird . I also do the same thing in a separate application and it works.

But still not working in the other application , i also tried the web view and same thing

Re: getfieldselection into variable not working

Or — Thu, 11 Mar 2021 14:31:01 GMT

Weird indeed. Perhaps you have competing triggers? At this point I don't really know what else to suggest... maybe try with a new variable / new name for the field and see if that fixes it.

Re: getfieldselection into variable not working

qlikviewuser20 — Thu, 11 Mar 2021 16:41:43 GMT

i create a new variable with the same configuration and it works 🙂