topic Re: Sheet Actions Not Working in Management & Governance

Sheet Actions Not Working

scottduthie — Fri, 02 Apr 2021 08:54:21 GMT

We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year' is selected from the MonthYear field - but it does not currently work.

We are using the formula Date(Today(),'MMM-YYYY') to find today's Month-Year, this returns the value 'Mar-2021', and we can see that we have a value of 'Mar-2021' in our MonthYear field. When we close the app and reopen, or just navigate away from the sheet and then back to it, the selection is not applied.

We have tried replacing the formula with a hard-coded text string of 'Mar-2021' and this also does not work.

Has anyone else experienced this issue in SaaS?

Re: Sheet Actions Not Working

Dalton_Ruer — Fri, 26 Mar 2021 17:26:34 GMT

I just tested and I am seeing the same behavior. An action works in my Qlik Sense Enterprise Windows site but not in my Qlik Sense Enterprise SaaS tenant.

Please create a support ticket for this. The wonderful thing about the Cloud is that when the issue is resolved it will be resolved and available very quickly.

Re: Sheet Actions Not Working

Damien_V — Mon, 29 Mar 2021 06:20:51 GMT

Hello @scottduthie

You do not need to open a support case. This behavior is working as designed in Qlik Sense SaaS.

The Engine session will remain open for 30 minutes after you close the app, as long as the Engine session is open, the sheet actions will not get triggered. If you wait more than 30 minutes and open the app again, it should work.

I believe we have a knowledge base article on this matter, let me find the details and get back to you.

Re: Sheet Actions Not Working

Dalton_Ruer — Tue, 30 Mar 2021 12:51:55 GMT

Thank you @Damien_V I think the Knowledge base article would help us understand.

Re: Sheet Actions Not Working

Damien_V — Tue, 30 Mar 2021 13:08:10 GMT

I found the KB article, however it didn't mention the sheet actions. I will update it mentioning the sheet actions as this is an information that we already have from Qlik R&D.

https://community.qlik.com/t5/Knowledge-Base/Qlik-Sense-SaaS-Unable-to-set-a-default-bookmark/ta-p/1783684

Re: Sheet Actions Not Working

scottduthie — Tue, 30 Mar 2021 13:54:15 GMT

Hi @Damien_V ,

The KB article makes perfect sense to me, but unfortunately our issue still persists. We have set up numerous tests and varying methods of creating the sheet action and it will not work. We are effectively trying to filter to a specific month when a sheet is opened. We have tried passing the value as an expression and also just tried with the plain text string like 'Mar-2021'. We have had all these tests in place for 24 hours - so the 30 min window is making no difference.

Is there something else we're missing? Can you only create actions on certain sheet types (like only base sheets for example) or only in certain space types or something?

Re: Sheet Actions Not Working

Damien_V — Tue, 30 Mar 2021 14:02:42 GMT

Hello @scottduthie

Can you provide details of how you have set the trigger (screenshots) and where the app is published (Managed space or Shared space) ?

Does it work fine with an app in your personal space with an action on a base sheet as you said ?

Re: Sheet Actions Not Working

scottduthie — Tue, 30 Mar 2021 14:13:04 GMT

In the attached screenshot you can see the expression being used to derive the value that should be used to filter the field MonthYear in the sheet action.

In the text box you can see the expression resolves to 'Mar-2021'.

And in the filterpane we can see that this value exists in the field MonthYear.

This is being done in 'My Sheets', but when publishing to 'Public Sheets' it also does not work.

The app is published in a shared space.

Re: Sheet Actions Not Working

Damien_V — Wed, 31 Mar 2021 12:53:33 GMT

Hi @scottduthie

Couldn't that be that the date field is stored in "number" format in the data model ?

Did you try to do the same with the "button" object, this one should apply the selection every time you click on it, and not be impacted by the engine session duration.

If that doesn't help narrowing the issue down, could you provide a sample QVF file with dummy data demonstrating the issue ?

Re: Sheet Actions Not Working

scottduthie — Thu, 01 Apr 2021 13:40:43 GMT

That's a good point @Damien_V .

The field MonthYear is created using 'dual' in the script. Great idea on using the button object to validate - I actually can't get it to select 'Mar-2021' from the MonthYear field.

I have tried using the plain text string 'Mar-2021' as the value to be selected from the field, and using an expression Date(Today(),'MMM-YYYY') which resolves to 'Mar-2021', and neither will successfully select 'Mar-2021' from the MonthYear field. How would you go about doing this?

Re: Sheet Actions Not Working

Damien_V — Tue, 06 Apr 2021 14:03:21 GMT

The easiest would be to add a filter pane, select the value you want from there, and check in the browser devtools > "Network" tab, filter on WS to find the websocket, then go in the websocket "Messages" tab and search for "select", you should be able to find the exact format it's using to select the value.

Re: Sheet Actions Not Working

scottduthie — Wed, 23 Jun 2021 21:08:39 GMT

Just winding up this thread.......

I managed to get this to work by setting the value that i wanted to select from the MonthYear field as:

=Date(Date#(varCurrentMonthYear,'MMM-YYYY'))

Where varCurrentMonthYear is a text string set in the script 'Jun-2021'.

So I have to tell Qlik that the text string 'Jun-2021' is a date in order for it to select that value from the MonthYear field - that's fine and makes sense to me.

I have tested this in a button and it works fine, so I can only assume it will work as a sheet action.

What I still do not understand is why I can't set the value as:

=Date(Today(),'MMM-YYYY')

This expression serves up the exact same date of 'Jun-2021' to Qlik, and Qlik knows it's a date because I've wrapped it in a 'Date' function.

Can anyone explain why this doesn't work?

Re: Sheet Actions Not Working

Skashid — Thu, 05 May 2022 10:48:49 GMT

Hi Everyone,

Greeting of the day !!

I had a query around the same topic for the sheet action 'select values in field' so I have specified the values for the field and the action is getting triggered for the sheet too but the action is also getting applied to other sheets in the application as well.

So my query is if the action is for the particular sheet how other sheets are getting affected by that action.

Please help me to understand.

Thanks in advance 😊