Underlying situation

When performing an initial load ("Reload Target...") with Qlik Replicate towards a Kafka target, it can happen that for one of loaded tables an error on Kafka (target) side occurs. In this situation usually several tables are loading in parallel (default parallelism degree is 5). When for one of these loading tables a target error occurs, then Qlik Replicate aborts the whole task and also the ones which are still loading fine. After this abortion the aborted tables are moved back to the "Queued" list. Several reload retries are done by Qlik Replicate and the same tables are picked out and are trying to be reloaded again and again, while for one of these tables the error on target side happens. Illustrated:

Reload Target - parallelism degree 5

Trial #1

• Table 1: loading (no errors)
• Table 2: loading (no errors)
• Table 3: loading (no errors)
• Table 4: loading (no errors)
• Table 5: loading - producing a Kafka error

After a few seconds of loading the task aborts.

Trial #2

• Table 1: loading (no errors) - producing duplicates
• Table 2: loading (no errors) - producing duplicates
• Table 3: loading (no errors) - producing duplicates
• Table 4: loading (no errors) - producing duplicates
• Table 5: loading - producing a Kafka error

After a few seconds of loading the task aborts.

Trial #3... same behavior as #2.. etc.

-> This behavior leads to (several) duplicates in the Kafka target topics for tables 1-4.

Idea description

Qlik Replicate could implement a smarter error handling in this case. In the above mentioned example 4 of 5 tables have no errors and are loading fine. They would finish, if the Kafka problem of table 5 wouldn't abort the whole task after a few seconds. So there would be two options / solution designs:

1) Qlik Replicate finishes the load of the tables, which have no problems, and then aborts the task. In this case Qlik Replicate should not get further tables from the "Queued" list, if an error occured. It should just wait, until the currently loading tables are finished and then abort.

2) Qlik Replicate moves the table with the error to the "Error" list and continues with the other tables. All tables without Kafka target errors can be finished thereby. In the end the task can finish or abort.

Either solution would prevent duplicates during initial load. 

Target audience

Qlik Replicate and Kafka Developers.

Additionally also the target system developers who receive the duplicates.

Value proposition

Duplicates lead to 

• higher storage consumption on Kafka cluster (and eventually further target systems)
• higher compute usage for producing and receiving the duplicate messages to/from Kafka Cluster
• higher network usage due to more unnecessary data being transferred
• additional cleanup effort
  • in case the Kafka topic has to be recreated and reloaded again to clear the duplicates
  • in case the final target system doesn't do an upsert (e.g. Kafka Connect -> GCP BigQuery, requires manual cleanup)
• etc.

All these negative impacts can be prevented by implementing this idea.

Case reference

This issue was described in case 31305 and an ideation was suggested.

It would be helpful to have a possibility to delete community bookmarks. Some bookmarks might become not relevant and when a person leaves the job bookmarks will keep hanging forever.

There is a current limitation when using Change table option with DB2 LUW as source:

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20LUW/limitations_db2.htm#ar_ibm_db2_456845099_1404155
"When the Change table option is enabled in the Store Changes Settings tab, the first timestamp record in the table may be Zero in some cases (i.e. 1970-01-01 00:00:00.000000)."

CDC functionality is thus not working - DDL changes are in some cases ignored by Compose.

Could this be fixed or a workable solution provided?

(Support case: 00037045: DB2 LUW source - DDL changes)

This is a request from a customer:

They would like to have owner in NPrinting the same way as Qlik Sense, which may help  to manage the authorization in a better manner. 

We are all aware of the buttons in Qlik sense with various functionalities including the navigation to next page. It would be very user friendly if we can navigate to the other pages by selecting a dimension from a chart without the use of buttons.

For instance, I have a pie chart 'Usage by Devices'. Upon selecting a device (Mobile for example) from the chart, it needs to be navigated to a sheet called 'Mobile Analysis'.

When printing to PDF in Qlik Sense server, it exports all of the features, extensions and values to the file, with no difference in visualization.

However, when the same app is in the cloud, and I download as PDF, the visualization is limited, some buttons are blank and missing fields.

I looked for this issue in the community, and found that there are some limitations when exporting in the Cloud, comparing to the server app.

I also found that this is an idea in progress to improve export PDF in the cloud: Sneak peak of reporting improvements on Qlik Cloud - Qlik Community - 1922236

It'd be a great idea if the funcionality matches both versions of the product, so we can work on the cloud without any limitations, like we do on the server.

Just for the matter of comparison, see screenshots attached of the same app downloaded as PDF in the Cloud, and in the server.

Currently exporting bookmarks from a Qlik Sense platform to another and/or from an app to another is not supported

Import / Export Bookmarks - Qlik Community - 1841307

I need to reload an application every 10 minutes.

Now 5 minutes is the closest interval, which causes twice as many requests as having a 10 minutes option would have.

Why not have an input field where I can input a number and maybe select seconds/minudes/hours/days... ? 

When a sheet is embedded in an iFrame on a web page, and the sheet contains a KPI or multi-KPI with a link to sheet, the link to sheet does not work. Enhancement/idea is to enable "link to sheet" when embedding KPI's or multi-KPI's in iFrame on web page.

So many countries, like in the continental Europe, South America and many Africa and Asia countries uses comma as decimal separator and dot as thousand separator.

Qlik has noted that as the number format and separators are set in the initial variables of any Qlik Sense document since the first version of Qlik Sense.

For some reason the new option to export table formats introduced in February 2022 ignores that number formats and doesn't apply any number format when it found that there is a comma as decimal separator.

I thought it should be reported as a bug but R&D thinks this is just a limitation, I can agree with them so here is an idea to remove that limitation and allow that half the world to keep the numbers in the formats they are used to read.

Hi,

Some customers asked us to be able to export pivot table data in the same format as "View data" menu option.
I also tried the export function like below

but it's not working as user expected.

Could be useful to have this functionality working as export of a linear table.

Best Regards

Currently, when we replicate views from the source endpoint, they are written into the target endpoint as tables.  We would like for views to be replicated as views, not tables - we need to retain the logic behind the views.  Please note, all of our use cases are full load.

Currently, when we replicate an endpoint, only the primary keys are created in the target endpoint.  We would like to have foreign keys also replicated from the source to the target.  Please note, all of our use cases are full load.

Longer APP names are trimmed from both tile & list view in Qlik Cloud hub/QlikSense SaaS. It makes more difficult if dashboard has different versions divided by region/country tagged to the end of the APP name. User can only see full name by mouse hovering over the trimmed APP name. 

In list view, Please add flexibility to adjust the column width, so user can adjust and see full name of APP in Qlik cloud hub. for example user can adjust the column width in Qlik cloud console -> Users -> 'All Users' view

There is no connector for Google Analytics V4 and more and more sites are migrating to that version.
In fact all our new sites are already in that version and that makes it impossible to use Qlik to centralize our information.

The Google Analytics Web Connector is currently only compatible for the Google Universal Analytics (UA). GA4 is due to replace the current version of Google Analytics (Universal Analytics or UA) in June 2023. More and more customers are now migrating to GA4. The GA4 comes with a new API (Google Analytics Data API). It would be great if the web connector becomes compatible for this new API, or that a new web connector is created. 

Hi, I think it'd be very useful to have an option to modify mutiple or all objects calculation condition in a sheet (or even an app).

Many times we build complex sheets (KPIS, Dynamic Text boxes, Graphs, tables...) but there's no point in showing any data until the user has selected a Year, Month, Business Location, etc.

The UI could be similar to the Variable UI adding a column for objectIID, title, visualization type, sheet name where it's present, and so on

From there we could select (all or one by one) and input a calculation condition and text.

Best regards

Currently, in pivot tables and straight tables, you can change the font size from the Style.
I would like to be able to change the font size for other line and bar charts.

Please enhance Qlik Replicate November 2021 to replicate Boolean data type from DB2 for LUW V11.5.7 to Azure SQL Server.  We’re getting “SQL invalid data type -7” error message on Qlik Replicate after upgrading to DB2 for LUW V11.5.7. 

The link suggests IBM DB2 for LUW Boolean data type is not supported.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20LUW/db2_db_data_types_source.htm?_ga=2.93359517.1607619055.1652207160-1609456532.1651150285

Hello,

In QlikSense there is the Nprinting On Demand extension object. 

The object needs to be configured with the Nprinting server URL to make the connection, etc. 

I was wondering if there was a way to configure this using a QlikSense variable instead of hardcoding the URL. 

I have been trying and it does not seem to take variables.. 

This would be very useful as we have multiple QS and NP environments.