Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
my department and I are currently bulding a new BI-Department.
At the moment I'm loading the TABLES from SF into Qlik. But I also have usecases where I have to concatenate several Tables.
One Engineer pointed out to my, why we're not using the views. So I tried to find usecased where people are using views and where the tables.
Unfortunately we have nobody in our team who is experienced in this kind of topic.
Is here anyone who can help me?
Qlik Sense: standalone Node.js update following the October 2026 security release
Following the Node.js security release of October 21, 2026, including the Brotli vulnerability CVE-2026-111497, I tested updating the Node.js binary bundled with Qlik Sense independently of a Qlik patch.
The test passed on Qlik Sense Enterprise on Windows May 2026 Patch 7, updating Node.js 24.18.1 to 24.22.1 This is a result from one environment, not a compatibility guarantee for every deployment.
This method is not validated by Qlik. Qlik's documented approach is to update bundled Node.js through a Qlik Sense upgrade. Test in development first, with a maintenance window and a recoverable full backup.
Check your current bundled Node.js version
Run in PowerShell:
& "$env:ProgramFiles\Qlik\Sense\ServiceDispatcher\Node\node.exe" --version
Using the full path checks Qlik's copy rather than another Node.js installation on the PATH.
Run the scripts
1. Extract the attached scripts into one folder.
2. Download the [official Windows x64 node.exe](https://nodejs.org/dist/v24.22.1/win-x64/node.exe).
3. Edit `NodeUpdate.config.psd1`: set the binary, backup and log paths, and the official SHA256 for "win-x64/node.exe" from SHASUMS256.txt.
4. In Windows PowerShell 5.1 as administrator, run:
.\01_Backup_Node.ps1
Continue only after BACKUP VERIFIED.
.\02_Update_Node.ps1
Leave the Service Dispatcher running before Update: the script handles stopping and restarting it. Relative paths are resolved against the configuration folder; execution is local to each machine.
Test Hub, QMC, application access, exports, reloads and your usual connectors, and check Qlik logs. These are recommended checks, not a list of checks confirmed by the test above.
For rollback, set `RestoreBackupDirectory` to the exact original backup folder and run:
.\03_Restore_Node.ps1
The scripts target the main Service Dispatcher on Node.js 24 only. They do not update EAPowerTools, Package Cache or npm dependencies. A binary backup is not a full site backup, and automatic rollback is not guaranteed. Recheck the installed version after subsequent Qlik maintenance.
References:
I have a table that currently works - it allows the user to select WeekStartShipDate, which is loaded in the load script with a Floor value, filtering the table to just one week:
The variables vStartSixWk and vEndSixWk determine the date range for the 6 Week column.
vStartSixWk =(WeekStartShipDate) -42
vEndSixWk =(WeekStartShipDate)
The 6 Week column is then calculated as follows:
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6
The % of 6Wk Total column is calculated as follows:
Num(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6
/
Sum(
TOTAL
Aggr(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6,
ShipTo
)
),
'##0.0%'
)
So, that all works fine until I add another dimension column, such as SalesOrder. Once I do that, the date filter breaks, and the 6 Week expressions return zeroes.
Please advise.
Hi,
Has anyone ever seen this error before? I encountered it on a logstream task:
00011524: 2026-10-04T03:00:01 [SORTER ]W: The record timestamp is at least 10 minutes later than the Replicate server time. Operation: BEGIN (6); Timestamp: Sat, 03 Oct 2026 17:00:47 GMT (1791046847000000); Replicate server time: Sat, 03 Oct 2026 16:00:01 GMT (1791043201849893); Stream position: 00000000.19489301.00000001.0000.00.0000:5773.491108.16 (sorter_transaction.c:204)
Thanks,
Mohammed
Hello,
I have a question about the upcoming End-of-Life of PostgreSQL 14 that has been announced last week (see https://www.postgresql.org/docs/release/14.24/)
Does anyone know if there will be an update that includes a newer DB version before we reach EOL for PostgreSQL 14 on November 12, 2026? As far as I'm aware, the most recent version of QlikSense still comes with PostgreSQL 14.22.2 included.
If not, do you have any recommendations on how to proceed? We do not want to risk running an outdated system database that cannot be patched.
If possible, we would also prefer not to migrate to a separate PostgreSQL installation as discussed e.g. in this thread: https://community.qlik.com/t5/Management-Governance/Moving-a-PostgreSQL-version-14-toward-version-17/m-p/2541205#M32534.
If there are no other options, I would be very interested in hearing from someone who has successfully moved to a separate DB installation and who is willing to share their experience.
Thanks!
I'm trying to setup a block to retrieve trust score information from datasets in my tenant. According to documentation I need to use a Qlik Cloud Services - Raw API Request and point to
api/data-governance/trust-scores/results/data-sets/actions/filter
After running the automation this is the response
{ "response": { "status": 404, "body": { "error": "Unknown Service (url: https://mytenantid.us.qlikcloud.com/api/data-governance/trust-scores/results/data-sets/actions/filter)" } }, "external error": false }
I've tried using curl to call this endpoint externally and it works fine.
I am working on a Qlik Predict forecasting use case using monthly historical data from 2021 to 2024.
The dataset contains:
DATE (For Each Month of the Year), PRODUCT_ID, Customer_NAME, Amount_USD
Our requirement is to use the historical monthly Amount_USD values to predict January–December 2025 for each Customer_NAME , Product combination.
Currently, while configuring the ML experiment, the Desired Forecast Window Size allows only 1, whereas our requirement is 12.
Additionally, the data is loaded from a database, and during validation we found that some values/counts in Qlik are not matching the source database.
Could you please provide detailed steps for:
This is my first use case in Qlik Predict, so a step-by-step implementation guide would be very helpful.
Hi guys i can't upload the image here, currently i faced an issue that trellis container can't hide dimension with null value. eg: i have 10 categories, and 3 of them has value, so only want to display 3, right now it displays all 10 categories. Even i do follow Trellis container | Qlik Sense on Windows Help instruction, do calculated column, turn off include null in dimension, turn off show all possible dimensions, nothing can help me archive that. Any answer for this issue?
Hello Qlik Community,
We would like discuss about a suspected issue in Qlik Replicate. After a source table is recreated and explicitly reloaded, Full Load completes successfully, but subsequent changes to that table are not captured. CDC resumes only after an additional Stop → Resume.
Environment
Qlik Replicate: 2026.5.0.423. Sourse and Target use same Microsoft SQL Server 2019, Microsoft SQL Server (MS-CDC)
The test uses two tables:
dbo.VersionTest — the table being recreated.
dbo.CdcHeartbeat — an unaffected control table. A stored procedure continuously generates committed updates to this table so that the task’s LSN position continues to advance.
The heartbeat procedure remains running throughout the experiment, including periods when the Replicate task is stopped.
VersionTest has a primary key and simple text/numeric columns, without LOB or rowversion columns. We reproduced this behavior in a laboratory while investigating replication recovery after BAS application table restructuring.
Steps to reproduce
Start the Replicate task and confirm that CDC works for both tables. Start the procedure generating continuous committed updates to CdcHeartbeat.
While the Replicate task is running, drop dbo.VersionTest.
Create a new table named dbo.VersionTestNG.
Rename dbo.VersionTestNG to dbo.VersionTest. The table now has the original name but a different SQL Server object_id.
Manually enable MS-CDC for the new dbo.VersionTest. Verify that changes to this table appear in the source cdc.dbo_VersionTest_CT.
Stop the Replicate task and wait until it is Stopped. Mark VersionTest for Reload while the task is stopped, then select Resume Processing.
Wait for Full Load to complete successfully. Execute and commit an UPDATE setting the test value to PROBE_A. This event appears in the source CDC table but does not appear in the target VersionTest__ct. Meanwhile, heartbeat changes continue reaching the target and advance the saved task position beyond the LSN of PROBE_A.
Perform another Stop → Resume Processing, without an additional Reload.
Execute and commit another UPDATE setting the value to PROBE_B. This change is captured successfully. The target VersionTest__ct contains the transition PROBE_A → PROBE_B, but the previously missed event that changed the value to PROBE_A is not recovered.
Expected behavior
After an explicit Reload refreshes the recreated table’s metadata, CDC should resume for that table.
If this DDL scenario requires additional recovery steps, we need a documented, supported procedure that prevents missed changes and clearly identifies when capture remains inactive.
Observed mechanism
At the first Resume, the capture component detects the missing old object and removes its registration. Reload subsequently refreshes the metadata for the new object, but the new CT is not added to the running capture component’s polling list.
The additional task restart establishes the correct registration and restores polling.
The task continues processing other tables and advancing its LSN while capture of VersionTest remains inactive. This creates a gap in the change history, which is critical for downstream historical processing.
An additional Stop → Resume restores future CDC processing but does not recover the missed interval. The current workaround therefore requires keeping writes to the recreated tables paused until Reload, the additional restart, and CDC verification have completed.
See e.g. https://www.heise.de/en/news/eMudhra-incident-compromises-eight-CA-certificates-11494689.html
Qlik Sense seems to use node.js and go. Thus, I expect qlik needs to be patched, right?
Please let us know which patches are necessary and their ETA if not yet released.
Navigation Deferring platform decisions? The Qlik Open Lakehouse Calculator puts a real cost to the status quo.
Qlik is a Leader in the IDC Events/Global Events MarketScape: Worldwide Data Intelligence Platform Software 2026 Vendor Assessment
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
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.
Your journey awaits! Join us by Logging in and let the adventure begin.