Web APIs having OAuth token authentication is one of the most common ways to secure an API. Currently API (Rest) support for OAuth is not available in Qlik SaaS. However, this is available in Qlik’s competitor : both in Power BI Desktop and Power BI Service.

Implementing Native OAuth support for REST API in Qlik SaaS would be a good asset for Qlik Cloud.

Microsoft documented OAuth connectivity in https://docs.microsoft.com/en-us/power-query/connectorauthentication#supported-workflow.

Briefly the Microsoft documented flow followed by Power BI is,

• Power BI makes the request to dataset API’s url to acquire the WWW-Authenticate header
• Based on the header, Power BI prompts the user to sign-in and acquires the token
• After successful sign-in, the jwt token acquired is passed to API as authorization header
• Note that, Power BI client takes care of token refresh scenarios using refresh tokens

Authentication with a data source - Power Query | Microsoft Docs

Our SAP HANA team have recommend any connection to HANA to be encrypted with SSL as part of our risk assessment.  

We would like to request for this feature in Qlik Replicate as soon as possible as SAP HANA source is the major (80% plus) source of data on our QR servers.

Reference QR case: 00036053: HANA end-point with SSL.

We need a way to automatically pass Qlik metadata (mainly app ID, app name, app owner, and Qlik identifier) when apps submit query jobs to BigQuery. This is needed so we can identify query jobs in the BQ INFORMATION_SCHEMA views originating from Qlik apps so we can measure Qlik's BQ resource utilization and take appropriate action.

At the moment the Quotas API on Qlik Sense SaaS returns a single record for app_mem_size and app_upload_disk_size. The Spaces API doesn't show this either.

When a customer has Dedicated and/or Expanded Capacity this can be different based on which Spaces are allocated to those.

Could the Quota API be enhanced to show the quotas per space / per capacity type or similar? 

and/or

Could the Spaces API be enhanced to show whether it's Normal or Dedicated or Expanded and what the quota limit is?

It would also be useful if they supported / showed Forts although the quotas here would be meaningless presumably as it's only limited by the customer's infrastructure for the Fort.

These improvements could then be leveraged by the App Analyzer.

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.

If you apply color expressions, the cells can for example color red for negative values. If the total value is also negative, the developer should be presented the option to have the Totals color red as well or not (standard black as it is implemented today)

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 have this request to be able to subscribe to straight tables where the sent email is an Excel file instead of a pdf. The excel should ideally have the same formatting as the table and definitely should also contain the Totals rows. 

Hi,
a customer asked if it's possible to disable the search tool in columns of tables.

This might be useful when a different dimension is used in the visualization in place of the real one that is available in filter panes and in the data model in general:

This way it's possible to avoid confusion or missing data due to different styling of fields.

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

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.

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. 

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.

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.

I just had a problem debugging my Qlik Sense app when it hung and I could not stop it. I tried refreshing the page but it didn't recover. I closed the tab, but then I could not open it again as it said "Reload in Progress".

I found a previous entry in "Ideas" (1525202) to have the ability to kill a hung task but it was closed saying that there is an abort button in the Data Load Editor.

The problem we need to solve is that I can't access the Data Load Editor as it said "Reload in Progress", so I am locked out of killing the task.

We need the ability somewhere in the hub or QMC to find these hung developer reload tasks and kill them from outside the Data Load Editor.

Thanks, Barnaby.

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'.

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. 

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.

When you use a Signed Lincense Key in using NPrinting, NPrinting licensing
service tries to connect to the license server license.qlikcloud.com,
but there is no way to know if the NPrinting licensing service is connecting
to the license server properly at the moment.

There are NPringing license logs in the following directory

ProgramData\NPrinting\License\Logs

And even if the following request's statusCode" is "200", you still can't
know if this request was successful in connecting to license.qlikcloud.com.

request
{"name":"V1LicensesAllotmentsProvisionListPost","req.method":"POST",
"req.url":"/v1/licenses/allotments/provision/list","res.statusCode":"200"}

The statusCode "200" is returned if the period is within delayed sync or
not after certain period of days.

The reason I'd like the feature to be implemented is that our customers
suddenly were not able to use the product after serveral days they changed
the proxy server or upgraded the product and license.config was overwritten
in upgrading the product.

It would be good if the NPrinting licensing service detects that
it was not able to connect to license.qlikcloud.com, the message appears
on the console of NPrinting or a mail message is sent to the
administrators.