Qlik Community Contest

We have a busy source table and have lots of transaction every minutes. However we don't see the table gets replicated under CDC into target. Source is MySQL 8.0.45 on premise while target endpoint is Snowflake AWS.

We have enabled target apply to verbose however it's not showing up as target apply in the logfiles. It only has source_capture.

23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]T: Event header: type=16, timestamp=2026-09-15 12:17:52 (1789489072), event_len=31, pos=1069454637, next_pos=1069454668 (mysql_endpoint_capture.c:1195)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: Event = 16, file_suffix=8666 (mysql_endpoint_capture.c:3072)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: Resuming=0, EventPosInFile=1069454637, EventHeaderNextPos=1069454668 (mysql_endpoint_capture.c:3097)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: Event timestamp '2026-09-15 12:17:52' (1789489072), pos 1069454637 (mysql_endpoint_capture.c:3148)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]T: > XID_EVENT (mysql_endpoint_capture.c:3201)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: Send COMMIT (7) record, record id -1795445488, stream position '$.008666:1069454637:-1:1069454668:37221256041509:$.008666:1069454456' (mysql_endpoint_capture.c:3722)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: read_next_binlog_event: next_pos=1069454668, curr_file=LUSQTTNDB04A-bin.008666, curr_file_len=1069454668, last_file=LUSQTTNDB04A-bin.008666, last_len=1069454668 (mysql_endpoint_capture.c:973)
23898836: 2026-09-15T12:17:52:393625 [SOURCE_CAPTURE ]V: Wait for new events... (mysql_endpoint_capture.c:981)
23898836: 2026-09-15T12:17:52:409223 [SOURCE_CAPTURE ]T: Wait minimum 5 seconds for next poll (mysql_endpoint_capture.c:994)

Hi,

How does increasing the readAheadBlocks internal parameter on an Oracle source endpoint increase the memory usage on the Oracle server machine? Thanks

Regards,

Mohammed

Hi Qlik Experts,
I'm experiencing weird behavior in Qlik Sense SaaS

I was trying out the forecast capability in line chart,and when I applied Section Access into the app, the line chart shows
lines which I'm not filtering at, and on shows the wrong date  
the chart, shows correctly, if I don't load the Section Access though.

does anyone experience the same thing?

scripts,  & images attached 

Hi everyone,

I'm working on a QlikView 12 application where I need to match sales transactions with promotional periods.

For each sale, I need to identify the promotion that was active for that article on the transaction date.

The promotion table contains something like:

ArticleCode | StartDate  | EndDate    | PromotionCode
------------|------------|------------|--------------
A001        | 2026-09-01 | 2026-09-10 | PROMO01
A001        | 2026-09-05 | 2026-09-15 | PROMO02
A002        | 2026-09-01 | 2026-09-30 | PROMO03

And the sales table contains:

ArticleCode | SaleDate   | Quantity
------------|------------|---------
A001        | 2026-09-07 | 2
A001        | 2026-09-08 | 1
A002        | 2026-09-15 | 5

I am currently using IntervalMatch to associate the sales date with the promotional interval.

The problem occurs when two promotional intervals for the same article overlap.

For example:

A001 | 2026-09-01 | 2026-09-10 | PROMO01
A001 | 2026-09-05 | 2026-09-15 | PROMO02

A sale on 2026-09-07 matches both promotions, so the sales record is duplicated.

This is expected behavior from IntervalMatch, but in my case I need to apply a business rule so that each sale is associated with only one promotion.

For example, if PROMO02 has priority over PROMO01, I would want:

A001 | 2026-09-07 | PROMO02

instead of:

A001 | 2026-09-07 | PROMO01
A001 | 2026-09-07 | PROMO02

The real script is more complex because there are several additional fields involved, but the basic problem is the same.

What would be the recommended QlikView approach to handle this?

Thank you!

Hi All,

I need some help in configuring Salesforce so that I can use the Salesforce connector with OAuth in Qlik Sense Enterprise Cloud.

For registering the App in Salesforce we need a callback URI?

Is there a standard Callback URI?

Or is any dummy value ok?

Further is there any example of how the setup of Salesforce Connector with OAuth includes the App registration in Salesforce?

Thanks

Naik

We are experiencing a recurring error when executing a Qlik Automation via its execution endpoint. This was working previously and has recently started failing.

Error message received:

{
  "message": "The POST method is not supported for route v1/automations/{automation-id}/actions/execute/{appId}?...
  Supported methods: GET, HEAD."
}

Example Automation IDs affected:

• 6499c600-4607-11ee-bela-01df9a62e147
• 9f93489-e286-4a4-87b8-a89abebble74

Details:

• The automation execution is being triggered via a POST request to v1/automations/{automation-id}/actions/execute/{appId}, which is the standard method for triggering an automation from an external application/webform.
• The API is now returning an error stating that POST is not supported on this route, and that only GET and HEAD methods are permitted.
• This is unexpected, as POST has previously worked for triggering automation execution and no changes were made on our side to how the request is sent.
• The issue is affecting multiple automations (not isolated to a single one) and multiple users, blocking business-critical data update processes for our team.

Questions:

1. Has there been a recent change to the Automations execution API that affects which HTTP methods are supported on the actions/execute route?
2. Is there a change required on our side (e.g. a different endpoint, authentication method, or automation trigger configuration) to restore POST support?

Hi Team,

My requirement will 3 sheets, Those 3 sheets need to include into single sheet in Qlik sense.

When I clicked Sheet1 it need to show as mentioned below.

When I clicked Sheet2 It need to show as mentioned below.

when I clicked Sheet3 it need to show as mentioned below.

sheet 1:

Filter1, Filter2, Filter3, Filter4 and respective grid of sheet1

Sheet 2:

Filter1,Filter2,Filter3 and respective grid of sheet2

Sheet3:

Filter1,Filter2 and respective grid of sheet1

Please provide step by step process if anyone know how to achieve the above requirment.

We configured an OIDC Virtual Proxy in Qlik Sense Client-Managed.

Login works (although we needed to block additional claim) but qlik doesn't call the logout flow in the OIDC provider.

We are connecting to an institutional provider that requires logout to be handled in order to allow the service usage.

It's not clear to us if this is not supported at all or we need to change configurations.

Also, are there workarounds for this?

thanks,

Gianluca

Hi,

In Qlik Sense Cloud, within the "Prepare Data" section of Analytics, I am trying to create a data flow where one of the sources is a REST connection. The issue is that, with a standard load script, I can easily modify this REST connection using the WITHCONNECTION clause, for instance, to fetch data for the current date.

Is it possible to apply this WITHCONNECTION variation from within a data flow source block?