Hi everyone,

We are experiencing an OAuth 2.0 authentication issue when trying to connect Qlik Cloud Analytics to Salesforce using the Salesforce connector from Add Data.

A new Salesforce External Client App was created following Salesforce's recent security changes.

According to Salesforce's updated security requirements, PKCE is mandatory for newly created applications, and the option to disable it is locked.

However, the Qlik documentation instructs us to disable PKCE as part of the connection setup.

We attempted to configure the Salesforce Callback URL using both:

https://connector.qlik.com/auth/oauth/v2.htm

https://connector.qlik.com/auth/oauth/v3.htm

Both attempts failed during authentication, resulting in the following errors:

redirect_uri_mismatch

OAUTH_APPROVAL_ERROR_GENERIC

We would appreciate hearing from anyone who has encountered a similar issue or has successfully established a Salesforce OAuth 2.0 connection in Qlik Cloud Analytics under the new PKCE requirements.

Thanks in advance for sharing your experience!

Qlik 製品について、10月にリリースされた新機能をご紹介します。主要な機能についてはデモも併せてご覧いただきます。

Qlik Cloud の分析機能、データ統合機能、管理機能、開発者向け機能など、また、Talendや適宜オンプレミス製品についても取り上げる予定です。是非、ご参加覧いただき、Qlikのさまざまな新しい機能をご活用ください。

Hello Talend Support Team,

We would like to request assistance investigating repeated Talend Remote Engine availability issues affecting our environment.

Since yesterday, we have observed multiple incidents where Talend Remote Engines become unavailable and then recover automatically a few minutes later. The issue has occurred several times and is now happening almost hourly.

Key observations:

• The issue impacts both DEV and PROD environments.
• The issue has been observed across multiple platforms, including Azure and GCP Remote Engines.
• Remote Engine services are automatically restarted when the engine switches to an UNAVAILABLE state.
• Multiple jobs are failing or being delayed during these outages.
• We reviewed the Talend/Qlik Cloud Status page and did not find any reported incidents for our regions during the affected periods.
• European regions (Frankfurt, Ireland, London, and Paris) are showing healthy status.

Example occurrences:

• 11-Nov-2026 19:42:41 - Remote Engine Alert
• 12-Nov-2026 00:16:41 - Remote Engine Alert
• 12-Nov-2026 01:26:41 - Remote Engine Alert

As the issue is occurring across different cloud platforms at nearly the same time, we would like to understand whether there were any Talend Cloud service disruptions, connectivity issues, authentication issues, or backend platform events that may have impacted Remote Engine communication.

Could you please review your platform logs and advise if any issues were detected during these timeframes?

Please let us know if you require additional logs, Remote Engine IDs, or tenant information from our side.

Thank you for your assistance.

Best Regards,
Gaurav Dighe

Hi all,

From time to time someone here asks how to get data from a website into Qlik when the site has no API: Trustpilot reviews, competitor prices, job postings, places on a map. One option is a scraper that saves its results to a dataset you can read over a REST API. I use Apify for this, so here is a setup built from the Apify API and the Qlik REST connector docs. It works the same for any Actor (a ready-made scraper) on Apify.

Disclosure: I build Apify Actors, and the two example Actor IDs below are mine. The steps work for any Actor, including the ones from Apify itself.

How it fits together

1. An Actor runs on Apify (by hand or on a schedule) and saves its results to a dataset.
2. Qlik reads the dataset of the latest successful run over the Apify API.
3. When you reload the app, you get the latest data.

Step 1. Get your own Apify API token

Create a free Apify account, then go to Console > Settings > API & Integrations and copy your Personal API token (docs: https://docs.apify.com/platform/integrations/api#api-token). Runs use your own account and its free monthly credit; each Actor page shows its price. Keep the token in the Qlik connection only, not in the load script.

Step 2. Run the Actor once on Apify

Open the Actor in Apify Console, fill in the input (for example a company domain for reviews), and start it. If you want fresh data every day, add a schedule in Apify (Schedules > Create new). Qlik will always read the latest successful run.

Step 3. Create a REST connection in Qlik

The connection needs at least one successful run to exist, so do Step 2 first. Then Add data connection > REST, with these settings:

• URL: https://api.apify.com/v2/acts/cliqtomedia~trustpilot-reviews-scraper/runs/last/dataset/items?status=SUCCEEDED&format=json&clean=true
• Method: GET
• Query headers: name Authorization, value Bearer <your Apify token>, and tick Encrypt next to it
• Pagination: none (the API returns all items in one response; see the notes for big datasets)
• Tick "Allow WITH CONNECTION", so you can use the same connection for other Actors
• Name it, for example, Apify

The response is a flat JSON array, one object per row, so "Select data" shows a single table (root). Pick the fields you need and insert the script.

Step 4. Load script

The script that "Select data" generates is fine (it may add __KEY_root key fields, which you can keep or drop). This is a shorter version for Trustpilot reviews, with the date turned into a real Qlik date:

LIB CONNECT TO 'Apify';   // in Qlik Cloud, if the connection is in a space: 'SpaceName:Apify'

RawReviews:
SQL SELECT
    "companyName",
    "rating",
    "title",
    "text",
    "date",
    "country",
    "url"
FROM JSON (wrap on) "root";

Reviews:
LOAD
    [companyName]                              as [Company],
    [rating]                                   as [Rating],
    [title]                                    as [Review title],
    [text]                                     as [Review text],
    Date(Date#(Left([date], 10), 'YYYY-MM-DD')) as [Review date],
    [country]                                  as [Country],
    [url]                                      as [Review link]
RESIDENT RawReviews;

DROP TABLE RawReviews;

Then a line chart of Avg([Rating]) by month of [Review date] plus a table of the low ratings already makes a useful sheet.

Step 5. Other Actors with the same connection

Because "Allow WITH CONNECTION" is on, you can point the same connection at another Actor. Only the Actor ID in the URL changes. This goes in the same script, after LIB CONNECT TO 'Apify'; (example: places from OpenStreetMap, shown on a map):

RawPlaces:
SQL SELECT
    "name",
    "type",
    "lat",
    "lng",
    "website"
FROM JSON (wrap on) "root"
WITH CONNECTION (
    URL "https://api.apify.com/v2/acts/cliqtomedia~openstreetmap-poi-extractor/runs/last/dataset/items?status=SUCCEEDED&format=json&clean=true"
);

Places:
LOAD
    [name], [type], [website],
    GeoMakePoint([lat], [lng]) as [Location]   // latitude first
RESIDENT RawPlaces;

DROP TABLE RawPlaces;

Then use [Location] in a point layer of a map chart.

Any Actor from Apify Store works the same way: its ID is in the page address (username/actor-name, written with ~ in the API URL).

Notes

• I checked the Apify side with real API calls: the runs/last/dataset/items URL returns a flat JSON array and returns 401 without a token. I have not run the Qlik script myself (no Qlik tenant at hand), so please correct me if a field name or option differs in your version.
• status=SUCCEEDED makes Qlik skip a run that is still in progress or has failed, so a reload never picks up half a dataset.
• Only some columns? Add &fields=rating,title,date to the URL. Nested fields: &flatten=address turns address.full into a normal column.
• Big datasets: add &limit=10000&offset=0 and loop over offset in the script, or just let the Actor save fewer rows per run.
• If you want Qlik to start the run itself, there is also POST /v2/acts/<actor>/run-sync-get-dataset-items with the input as JSON body. It waits up to 300 seconds, so it only suits small runs. For anything bigger, schedule the run in Apify and read runs/last as above.

How do you bring web or API data into Qlik today: REST connector, file drops, or something else? And has anyone used a paginated REST connection for this kind of API?

It’s Git O’clock for your Qlik Sense routine! 
Add Gitoqlok to your application development cycle and enjoy the Continuous Integration perks as well as tricks for easing your working routine.

Gitoqlok is an easy-to-use tool for version control and collaborative development in Qlik Sense. Via integration with several Git providers (GitHub, GitLab, BitBucket, etc.), the extension opens the gates to the world of version history. Any change made in the application by the user can be tracked and restored at any point in time - milestone your work and enjoy the visual time travel between different versions of your application - and don’t switch a single window.

Regardless of your team’s size, Gitoqlok is the remedy for the headache of conflicting changes - the git system inherited in Gitoqlok detects developers’ copies of applications, stores their changes in independent branches, and aids in detecting collisions for published applications.

Version control is not the only offering Gitoqlok has up its sleeve. In the favor of advancing your development process by reducing manual routine work, you can:

       ✔ Immediately find an application that generates a QVD file in Data Load Editor;
       ✔ Set covers for the sheets in just a few seconds;
       ✔ Use the AI capabilities to generate Sheets and Master Measures titles and descriptions;
       ✔ Migrate Qlik objects between different Qlik environments and backup restore, and many more!

Learn more about the whole spectrum of features on https://docs.gitoqlok.com/

Join our Slack community https://app.slack.com/client/T012RHLTWHL

Try Gitoqlok yourself https://chrome.google.com/webstore/detail/gitoqlok/kkgicbgpgfcbhcbmifmfagggnpkebdaj?hl=en

I would like to check if we could use the tool Qlik Sense PostgreSQL installer if we are using Standalone PostgreSQL since the first time we installed Qlik Sense cluster.

I have a pivot table that I am trying to cumulate the sum of rows for YTD Tonnes and Margin %.
I need it to look like below:

I use these for a normal straight table.
RangeSum(Before(TOTAL Sum({<FYMonth>}Tonnes), 0, Rowno(TOTAL)))
and
RangeSum(Above(TOTAL Sum({<FYMonth>}Margin), 0, Rowno(TOTAL)))
/Rangesum(Above(TOTAL Sum({<FYMonth>}Sales), 0, Rowno(TOTAL)))

I have tried this for the pivot table but it is not working. I have also tried “Before” rather than “After”.
RangeSum(After(TOTAL Sum({<FYMonth>}Tonnes), 0, ColumnNo()))
And
RangeSum(After(TOTAL Sum({<FYMonth>}Margin), 0, ColumnNo(TOTAL)))
/Rangesum(After(TOTAL Sum({<FYMonth>}Sales), 0, ColumnNo(TOTAL)))

Hello all! 🙂 
So in my QMC, it seems the message banner is cut in half - i.e. only the background. The text looks cut in half, however is visible if you high-light it. 

I suspect it came with the upgrade to September 2025 SR2; anyone else had that problem and how did you fix it, if you fixed it? 🙂 

Cheers

Jörgen