Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have e request to make nprint excel report. I developed a table in qliksense with required columns. The excel report should be in particular excel design with headers and boarders. So in order to do it , I unchecked 'Keep sources' for the whole table. But I have issue with one column which has conditional font text coloring. When I do uncheck 'Keep sources' , its color disappears. And if I do 'Keep sources' only for it, it does not have boarders and the text moves to the right. Conditional coloring in excel itself does not suit, as conditional coloring in qlik is based on variables. Please help:)
Thanks,
Inna
Hi All,
Greetings!
I have Date dimension in Qliksense straight table, and measures are Production, Sales and Consumption of Stock Material for Inventory in metric tons....
I am getting all values correct. For opening stock column, I have written the formula in the table expression as
if(Date=min(total Date), Sum([Initial Stock (MT)])
,
RangeSum(
Above((
Sum([Initial Stock (MT)]) + Sum([VCM Arrival (MT)])
- Sum([Consumption SPVC (MT)])
- Sum([Consumption PPVC (MT)])),
1,
RowNo()
)
))
which is giving correct values.. But, I need to execute the same in Qlik backend script. I tried this :
Kindly Help!!
Thanks in advance!!
Niranjana
Hi,
A client of hours has a set of tasks that write to Synapse. Every now and then, all downstream tasks experience a disconnection from the target, however tasks manage to recover and continue.
RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10060 Message: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. [1022502] (ar_odbc_stmt.c:4737)
This happens on all downstream tasks writing to different instances of Synapse so I don't think it is a target endpoint issue. Rather I believe it could be something to do with the Qlik Replicate windows server. Also, it also looks like Qlik Replicate is trying to use higher outbound ports to Synapse such as 56757, but the documentation states that it will only use ports 11000 - 14999.
The client has suggested that it may be due to port exhaustion issue, and have suggested the following Windows registry changes:
They asked us to verify whether this makes sense. Can anyone verify whether a port exhaustion issue could cause this to happen? i.e. All connections to the target to drop all at once. To me it doesn't make sense that all downstream tasks are dropped at the same time due to a port exhaustion issue, however I could be wrong. If this needs to be a support case instead, please let me know. Thank you.
Regards,
Mohammed
Hi.
My team have been tasked with moving our existing Replicate solutions to a new sever.
During the training, we were advised that we could use repctl to create a repository file, and import it into the new enviornment.
repctl -d D:\Attunity\Data\LogStreams exportrepository
repctl -d importrepository json_file=c:\temp\repositoryfile.JSON
My only concern, is that we'd like to guarantee that, when we import the repository into the new location, that none of the tasks are automatically resumed.
I'd also prefer not to stop the tasks prior to running the first command.
If the service account in the new environment does not have access to the target databases, will that suffice as a method? Will that guarantee that any writing tasks won't start?
Thanks.
Hello,
We are using QSEoW. We have an app that does not contain Section Access and is published to a stream. It contains a valid data model, contains data and has a dozen sheets with charts. Some users can open the app and see the data just fine. But other users get "Access Denied" error message. I've checked the following items for one of these "Access Denied" users:
User Access on the App Objects
User Access on the App
User Access on the Stream
Licensing (the user is Allocated)
User account, all looks good there.
User Directory Connector, all appears to be working here as well.
I don't know what else to check. I tried looking through some log files on the server but honestly don't know what I'm looking for. I'd really appreciate it if someone could give me some other things to check or point me to a specific keyword in a specific log file look for.
Best regards,
Steven
Hello Team,
I am working on writeback table for the User Entries. The requirement is when the User Enters the data, I want to store them in the backend and once I am reloading the application, those data appear in the filter, charts, KPIs and in the Table, also it shows the Updated data. I am not having S3 as connector to connect with Qlik Sense. Available options I am having is PostgreSQL, Amazon RedShift, Rest API (Direct Access gateway), Athena (But this is a Query Editor not a Database storage)
Due to Access Limitation, I am not having a permission to create an API key.
which would be the best option for me to discuss with the client for the Access.
Note: I am thinking of using PostgreSQL and connecting with Qlik sense using Username and Password.
I highly welcome your suggestion on the above-mentioned doubt.
Hello ,
We are in a business context where apps are reloaded in qlik sense client managed and then pushed to Qlik cloud tenant via multi-cloud distribution mechanism .
This is working fine but we have no access to app settings in the qlik cloud tenant for a distributed app, and thus we cannot activate qlik answers on it .
________________________________________________________
Hi, I was wondering if anyone has experienced the same or has a possible solution / reasoning.
Qlik Sense SaaS Cloud Version.
I have been a Qlik developer for 15 years now, and created 100s of apps and ETL scripts, and I have not experienced this before.
I've modified an existing ETL that I own to store out an additional new QVD this week.
If I search the catalog I can see the QVD in the correct space. However, If I go to my Data Sources, navigate to the correct space and Select Data, my new QVD does not appear in the list of data files in that space.
I can manually script to load in the QVD, which works, so I know there is nothing wrong with the file itself.
I've deleted it, re-written the script to create it, I've tried everything I can thing of.
Any suggestions would be gratefully received, Thank you
The other day I upgraded a client-managed Sense cluster from 2025-Nov-patch<something> to 2026-May-IR.
Upgrade finished as expected, did a reboot of all the nodes and tried to log in.
Got this:
Standard login page results in this after upgrade to 2026-May-IR
Nothing obvious in the logs (did a quick check, admittedly I may have/probably missed things..).
Rebooted all servers again - same thing. Let the system sit for a few hours, same thing.
But hey - 2026-May-patch2 is out - let's apply that.
Again, the installers finished as expected, and surprise - after starting the various Sense services everything works again. Nice.
Something in patch1 or patch2 seems to have fixed the issue, the slightly disturbing thing is that the release notes do not really mention any fixed bugs I connect to the experienced issue.
But the issue is fixed, if anyone else comes across this issue it's worth trying an upgrade to latest patch before calling support.
Looking beyond that little upgrade speed bump, 2026-May adds quite a few nice additions, both for admins in the QMC (task history - looking at you - yay!!) and end users in the form of new and improved chart objects and other UI facing features.
Change log here.
See why Qlik was named a Leader in the 2026 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms
Walk through six new AI capabilities now generally available in Qlik and start applying agentic data engineering to your team’s workflows.
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Yesterday’s innovations are today’s table stakes. BARC reveals modern ISVs’ most essential capabilities.
Your journey awaits! Join us by Logging in and let the adventure begin.
Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.
AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture
Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.
Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
Migration to Qlik Cloud Analytics optimizes analytics applications within months.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.