I have this table with Name and Color

ColorData:

I want to get all the distinct sorted combinations of each name. Joined by a pipe | symbol.

ColorDataCombos:

Note: if it is not possible to get sorted and distinct ones that’s fine. I’ll take all permutations for each name even though there may be many

HI, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:

I simply put into 'Query *' field:
call schema.procedure_name();

The block usually keeps running for a 2 hours 5 minutes or eventually times out, even though in PostgreSQL the procedure is triggered immediately and finishes in less than a millisecond (based on my logs).

Do you have any experience or recommended block/workaround for this?

Thanks!

Hi,

I am currently testing Qlik Sense embedding and would need some assistance. We use Qlik Sense Enterprise with ticket authentication and users are on our Active Directory.

I have created a second virtual proxy for embedding with the following settings and also added central proxy:

• Prefix: embed

• Session cookie header name: X-Qlik-Session-Embed

• Anonymous access mode: No anonymous access

• Authentication method: Ticket

• Has Secure attribute (HTTPS): Enabled

• SameSite attribute: No attribute

In Postman, I added the Qlik Sense certificates and used the following request configuration.

Headers:

• Content-Type: application/json

• X-Qlik-Xrfkey: 1234567890123456

Body:

{
  "UserId": "ADUser",
  "UserDirectory": "OurADUserDirectory",
  "Attributes": []
}

I then send a POST request to retrieve a ticket using the following endpoint:

https://server.com:4243/qps/ticket?xrfkey=1234567890123456

The request returns a ticket successfully.

However, when I paste the following URL with ticket into the browser using an incognito window, I am still prompted with a login dialog (Internal Windows Authentication):

https://server.com/embed/?qlikTicket=TicketFromPostman

Does anyone have any idea what might be missing or misconfigured?

Hello everyone,
I have watched some presentation videos about the new Write Tables and I would like to clarify a few points.

From what I understand, Write Tables allow updates only on one or more columns associated with an existing record based on a defined key, but they do not allow inserting new records. Is that correct?

For example, if I want to manage a forecast by country, I could define the country as the key and have an editable column with the forecast amount. In this case, if I need to add a new country, is it possible to do it directly in the Write Table, or must the country already exist in the underlying dataset?

Another point that is not completely clear to me is the 90-day retention of the changes. What exactly happens after 90 days?

Continuing with the forecast example, if this table is used to display the forecast throughout the year, would the editable values for rows that have not been modified for 90 days be removed?

I understand that modified data can be extracted before they are deleted, but in a management table like this I cannot clearly see the practical usage. For example, I cannot write the edited value into another non-editable column within the same table.

Thanks in advance for any clarification.

(Connector error: closing data chunk stream from client) from File Access Gateway

What seems to be causing this error and how can we resolve it?

Attached here are the logs and content of the json file stated in the connectoragent logs

Qlik Data Gateway  

Good day, Qlik Community!

I have a new article on Data Voyagers, the first of 2026! It is about Matching algorithms. Although we can use Talend Studio for these tasks, this article is valid even for non-talend users.

It breaks down each method to verify if two records are simular. It is a very detail article, another one of my series "the theory behind Qlik".

Read it here:

The Art of the Match (and How to Survive It)

The much requested Word & PowerPoint add-ins are now generally available to support expanded report authoring from Qlik Cloud Analytics.  Notable links: 

• Support bulletin https://community.qlik.com/t5/Support-Updates/Developing-Word-and-PowerPoint-reports-with-the-expanded/ba-p/2540478 
• Help https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/reporting-add-ins.htm

Hello,