Qlik Sense Sheet Actions

JonStreet — Sat, 16 Nov 2024 02:28:48 GMT

We have recently installed the April release and want to start using the new built in sheet actions. We were previously using an extension to handle this. In our extension we had a really simple script which, when you entered a sheet, checked if there were any selections in the field and if there were not it would set the selection to a variable. We were using the "Select Values in a Field" action. The script was simply:

=if(GetSelectedCount(Month)= 0, vCurrentMonth)

Having applied the same logic to the built in Sheet Actions I am getting some strange behaviour. If there are no selections in the field it works fine and carries out the selection correctly, however if there is already a selection in the field, instead of doing nothing, it is deselecting everything so there are no selections.

I tried to change the script to =if(GetSelectedCount(Month)= 0, vCurrentMonth, GetCurrentSelections(Month)) but this did not work either it acted the same. If the script just reads =vCurrentMonth it sets it every time to current month but this isn't what I need.

I am trying to get it to set to the vCurrentMonth if there are no selections in month but if there are selections leave them as the current selection.

Any ideas? This feels like a bug to me?

Re: Qlik Sense Sheet Actions

pauline_rqn — Fri, 27 Nov 2020 13:21:33 GMT

Hi JonStreet,

Do you have a solution? I have the same issue and it seems to be a bug.

Thank you.

topic Re: Qlik Sense Sheet Actions in App Development

Qlik Sense Sheet Actions

Re: Qlik Sense Sheet Actions