Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Arvind_07
Contributor II
Contributor II

Sheet Action for Dates

Hi All,

I have multiple sheets and on the first sheet- I have added a sheet action- 'Select values in a field' on the sheet properties.

This is the expression I have used on the action =if(getselectedcount(Date)=0,num(WeekStart(today()-7)),Date)

The problem I face with this sheet action is- 

1. Whenever I open the sheet for the first time which has the above sheet action that was setup is not working, as it only works when I reload/refresh the page.

2. Once the Action got applied after refreshing the sheet and if I apply filter on any of the other sheets and come back to the first sheet which has the action- the action on the first sheet is not working at this point of time and shows only the filter that was selected on the other sheet. And if I refresh the sheet again, it shows the action and also the filter that was selected on the other sheet

Is there a way to show the sheet action when I open the sheet for the first time instead of refreshing the sheet to show this action?

Please advise

Thank you.

1 Reply
Arvind_07
Contributor II
Contributor II
Author

Could anyone please advise on this. Thanks