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:

• MaxUserPort (Set to 65534 Decimal) – Expands the total pool of available outbound ports.
• TcpTimedWaitDelay (Set to 30 Decimal) – Reduces the socket cleanup cooldown from 240 seconds down to 30 seconds.

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.

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.