Not able to handling huge data volume and exporting to excel entire app with single click
I feel disappointed that we are currently unable to fully achieve the business requirements through Qlik. At present, we are mainly replicating reports from SAP into Qlik Sense Enterprise.
In the current project, we are facing performance issues due to the large volume of data being loaded into Qlik Sense on a daily basis. Users require access to all historical data. However, when the full historical data is included, the application itself fails to open because of performance limitations.
To address this, we implemented a reload button with read access and provided input variable boxes. This allows users to reload data for specific historical dates when needed. However, we are facing a challenge: when we grant users read access to enable reload functionality, they are able to initiate the reload, but after completion, they receive an "Access Denied" error.
Additionally, users require the ability to export all object data with a single click. Another issue we are encountering is that during export, objects without a defined title are displayed with gibberish or system-generated names instead of meaningful labels
Thank you for sharing the information. It is very helpful for us.
With Analyzer access, can a Hub Admin reload the app using a button?
Also, when exporting through Qlik NPrinting, if users apply filters in the Qlik dashboard, can those same filters automatically be applied in Qlik NPrinting instead of setting the filters again in NPrinting?
You are running into a few different (separate) Qlik issues at once. I will keep your wording, then map each one to what is likely happening, and what to do next.
“When full historical data is included, the application itself fails to open because of performance limitations.”. This usually means the app is trying to hold too much detailed history in memory at once, so open time and calculations become too heavy. The simplest first step is to increase the server specs. Give it more power will directly benefit performance.
“We implemented a reload button… users can initiate the reload, but after completion, they receive an ‘Access Denied’ error.” Reload is a governed operation in Qlik Sense Enterprise, and “read” rights do not equal “reload and save” rights. You may need to give users the HubAdmin privilege and allow them to reload the app from the HUB before entering it. That avoids permission conflicts.
“Users require the ability to export all object data with a single click.”. That requirement is closer to reporting than interactive analytics. The simplest way to meet it is to use Qlik NPrinting to generate a governed Excel output (on demand or on a schedule) rather than relying on users exporting each object manually. But if NPrinting is not an option, increasing the server specs (CPU and Memory) will definitely resolve this. Qlik Sense has no default limit to exports. It is the server that is running out of memory. It would be nice to see some RAM and CPU metrics from the server during the export.
“During export, objects without a defined title are displayed with gibberish or system-generated names.”
Object titles are not mandatory, but optional. If the object doesn't have a name nor title, Qlik will fall back to internal object identifiers. The simplest fix is to turn on titles and give every exportable object a meaningful title (and, if needed, align on a basic naming convention like “Sheet Name | Object Purpose”).
Welcome to the Qlik Community. The early pains of adopting and learning a new tool can feel overwhelming, but the community is here to support each other.
Please give it a like, mark it as Helpful or Solution if that was the case.
Live and Breathe Qlik & AWS. Follow me on my LinkedIn | Know IPC Global at ipc-global.com
Thank you for sharing the information. It is very helpful for us.
With Analyzer access, can a Hub Admin reload the app using a button?
Also, when exporting through Qlik NPrinting, if users apply filters in the Qlik dashboard, can those same filters automatically be applied in Qlik NPrinting instead of setting the filters again in NPrinting?
