topic Re: Real-time data refresh based on the user access to the dashboard -Qlik Sense in Qlik Automate

Real-time data refresh based on the user access to the dashboard -Qlik Sense

kannekantiOH — Tue, 09 Jul 2024 15:09:53 GMT

We have encountered a scenario to implement in the Qlik Sense dashboard where the dashboard should be refresh based on the user access.

Scenario: We have plan to build the organizational hierarchy to access the dashboard based on the user access. So that users/managers can see the data related to their employees (at all levels). We have built the SQL store procedure to pull the all-subordinate employees based on the user-id(manage id).

In the Qlik sense (enterprise edition), it is possible to refresh the data in real time (by call/trigger the procedure based on the user id) when user log into the dashboard?

Re: Real-time data refresh based on the user access to the dashboard -Qlik Sense

TheLazyDevelopr — Tue, 09 Jul 2024 22:06:16 GMT

Not sure if possible for a reload based on when a user logs in but why not just add a button with an action that will reload data? You can create a condition to only enable the button for certain users as well.

Re: Real-time data refresh based on the user access to the dashboard -Qlik Sense

Or — Wed, 10 Jul 2024 09:12:58 GMT

This isn't really how Qlik works. There's only one copy of the app in memory, so if you made something like this, it'd only work for a single user. I'd suggest having a look at using ODAG or Dynamic Views for this sort of thing instead.

Re: Real-time data refresh based on the user access to the dashboard -Qlik Sense

Ciya — Wed, 10 Jul 2024 21:26:32 GMT

It's possible using dynamic view or ODAG