Hi,

for example, this expression "=today() - date(date#('20200920','YYYYMMDD'))"

returns 1879 as a result and I need to show number of years, months and days between those 2 dates.

Thanks

After upgrading to the latest patch in December. The visualization bundles stopped working and displayed as invalid visualisations.

Looking into the issue the had disappeared from the extension list.

I have trie dthe following

modifying / changing / repairing the bundle installation - no change.  am unable to remove as that option is greyed out.

When I check the logs I am getting the following errors- 

350 20250204T084038.700-0500 WARN System.Repository.Repository.Core.Resource.Support.ExtensionResourceSupport 50 d0117ad3-fb66-4122-8803-96f6472d5efa<username> Failed to add extension Exception of type 'System.Exception' was thrown.↵↓ZIP file error at Repository.Core.Util.ZipUtil.UnzipFile(String filePath, String destinationFolder, String password, Boolean deleteZipFile, String fileFilter)↵↓ at Repository.Core.Util.ZipUtil.UnzipFile(String filePath, String destinationFolder, String password, Boolean deleteZipFile, String fileFilter)↵↓ at Repository.Core.Resource.Support.ExtensionResourceSupport.Add(String path, String password, Boolean appendPrivileges, Boolean replaceExtension) c0de923a-c1c9-2f6b-db41-ae357858ccba d0117ad3-fb66-4122-8803-96f6472d5efa

This is from the install log
Error: POST /qrs/extension/upload?privileges=true&pwd=&xrfkey=4yAjqKO6JQCbPLow: 400

Nothing else has changed other than he patch which was released as a security upgrade.

Hello,

I am working with a pivot table in Qlik Sense with dynamic dimensions. The dimensionality is not fixed and might be affected by selections on two different data islands. I have to be careful as hidden dimensions impact this problem, as GetObjectField() can return a blank result ('') if the dimension's condition is not fulfilled.

For my app, I need to compute percentages for each dimension by using the TOTAL qualifier with a different number of fields according to the dimensionality of the pivot table. The problem is users are allowed to change the order of the dimensions by moving the fields in the pivot table. For instance, they might put field2 before field1, and all other possible combinations.

Therefore, the order for the dimensions is really important as I compute the TOTAL according to the dimensionality of the table and the order of the fields. I use GetObjectField() along with variables to define the first dimension that is shown, vFirstDimension, defined as:

if(len(GetObjectDimension(0)) > 0, 0,
    if(len(GetObjectDimension(1)) > 0, 1,
        if(len(GetObjectDimension(2)) > 0, 2,
        ''
        )
    )
)

 Therefore, I can now use GetObjectField($(vFirstDimension)) to get the first dimension shown. For the second available dimension, I define vSecondDimension:

if(len(GetObjectDimension($(vFirstUsedDimension)+1))>0,$(vFirstUsedDimension)+1,
	if(len(GetObjectDimension($(vFirstUsedDimension)+2))>0,$(vFirstUsedDimension)+2,''))

This does work, but as you can imagine, there are plenty of nested if statements, and the final app is getting slow because of this.

Note: dimensions are shown according to the selections made on a data island; however, I can't simply concat the field as it won't respect the order when moving the field order in the pivot table itself.

Do you have any suggestions for resolving this performance problem?

Thanks in advance.

Greetings,
Alex

hi all,

I have Source as oracle and target as Databricks Delta tables on GCP. Here Qlik not support for the Cloud native function as Data enrichment function in the 2024 and 2025 Version.

So i added one column manual at the target DBRX end as Current_timestamp.

ALTER TABLE vvv ADD COLUMN audit_created_datetime TIMESTAMP;
ALTER TABLE vvv SET TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported');
ALTER TABLE vvv alter column audit_created_datetime set default current_timestamp();

But here when i get full load using Qlik replicate i need Current timestamp and when ever i got INSERT i need the col audit_Created_Datetime as current_timestamp values.

Even i add as Replace column value as audit_Created_datetime as datetime('now', 'UTC'). i got NULL in the column kindly give the solution.

Hello Comunnity,

I followed all the installation instructions from the official documentation for Qlik Data Gateway – Direct Access.
The installation process completes successfully, but when running the following command to configure the tenant:

connectoragent qsc set_config --tenant_url XXXXXXXX.us.qlikcloud.com

the service fails to start and returns the following error message:

Dynamic port binding is not supported when binding to localhost. You must either bind to 127.0.0.1:0 or [::1]:0, or both.

I have tested this using a cleam SO Windows Server 2025, 2022, and 2019, (AWS Ec2 instances) and the issue occurs in all of them.

The environment includes the following .NET runtimes, which are installed automatically with the latest Qlik Data Gateway (Direct Access) installer:

Could you please confirm if this is a known issue or if any specific .NET version or configuration is required to support Kestrel on these Windows versions?

Thank you for your help.

Best regards,



This is the full error message:

C:\Program Files\Qlik\ConnectorAgent\ConnectorAgent>connectoragent qsc set_config --tenant_url XXXXXXX.us.qlikcloud.com
connector-agent starting as standard .net core process....
{"TimeStamp":"12-11-2025 13:32:21.729","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"environment-info: GatewayVersion=1.7.8, AgentVersion=1.31.2, ProcessorCount=2, WorkingSet=35 MB, OS=Microsoft Windows NT 10.0.17763.0, TimeZoneOffset=00:00 (0.0)","Exception":null}
{"TimeStamp":"12-11-2025 13:32:21.903","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Using default port from config 0","Exception":null}
{"TimeStamp":"12-11-2025 13:32:21.903","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Setting CONNECTOR_AGENT_PORT for non-default port","Exception":null}
{"TimeStamp":"12-11-2025 13:32:24.312","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Log options enabled: 'NONE'","Exception":null}
{"TimeStamp":"12-11-2025 13:32:24.317","ProcessId":"3128","Thread":"1","Level":"WARN","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"If AGENT_LOG_OPTIONS are configured, then at least one logging option must be enabled. All non-verbose logging options at the current AGENT_LOG_LEVEL will be enabled.","Exception":null}
{"TimeStamp":"12-11-2025 13:32:24.318","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Trace: RelayCommand enabled and will be output to DirectAccessAgent.log","Exception":null}
{"TimeStamp":"12-11-2025 13:32:24.319","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Chunks ack capability is not supported","Exception":null}
{"TimeStamp":"12-11-2025 13:32:24.71","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"AsyncLoadDataRequest is disabled. Connector startup timeout set to 30 seconds per attempt with 3 max attempts","Exception":null}
{"TimeStamp":"12-11-2025 13:32:26.935","ProcessId":"3128","Thread":"1","Level":"ERROR","Message":"System.InvalidOperationException: Dynamic port binding is not supported when binding to localhost. You must either bind to 127.0.0.1:0 or [::1]:0, or both.\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.LocalhostListenOptions..ctor(Int32 port)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.ParseAddress(String address, Boolean& https)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.AddressesStrategy.BindAsync(AddressBindContext context, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.BindAsync(ListenOptions[] listenOptions, AddressBindContext context, Func`2 useHttps, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.BindAsync(CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.StartAsync[TContext](IHttpApplication`1 application, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Hosting.WebHost.StartAsync(CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String startupMessage)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String startupMessage)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.Run(IWebHost host)\r\n at Qlik.ConnectorAgent.AgentProcessBase.StartAgent(String[] args, Boolean isService)","Exception":null}

Not sure if this is a feature or a bug -  but if a line chart is painted with its point/line count limited, where points are pruned from a chart, they're displayed as zeros .

For example I'm rendering a historical FX rate chart  - at first I had a heart attack as I thought we were missing data.

When I zoom in with the scroll wheel, they eventually paint up.

Ideally, even though the points may be being pruned, I'd expect the behaviour to be similar to below, where gaps were connected ( as set in 'Missing Values >  Show as connections ) 

If I can get my access to the Pendo.Io  login for the Ideation I'll post it there.

Hi Team,

I am planning to set up Email alerts for reload failures in Qliksense QMC. I have gone through some discussion over community and found that https://github.com/NickAkincilar/QlikSense-Task-Failure-Email-Alerts

Can any one help me with setting up this in my Qliksense server(Mine is Single node server)??