We are planning to extend Qlik replicate to replicate the data from AWS Aurora PostgreSQL but I have come across that there is no support for Before Image record. It would be great if you could take this as a feature request and prioritize it. 

Hi Experts,

I have a loop automation that runs continuously until the timeout of 14400 seconds.

The automation fails few seconds before the 4 hours limit, so when the schedule time arrives it should be executed again.

The problem is that the automation skips some executions during the day without any errors or log file.

Is this a bug?

Best Regards,

Michela

Is there any way to remove Cloud Engine from the Task Config in Cloud?  I have a cluster I run of servers on AWS setup and I do not use Cloud Engine at all.  I have a separate workspace (not default) and it still shows 2 cloud engines in my drop down when configuring a task.  Even though I have it turned off.  I would prefer not to see Cloud if cloud is turned off.  Every job we setup defaults to cloud and we have to change it to our cluster each time.

Hello,

I want to remove a colum from dynamic type input in tjavarow.

I tried this but it didn't work :

Dynamic dyn = row3.table;

dyn.removeColumn("NameColonneToDelete");

Can anyone help me ?

Thanks

Hi everyone!

I have a QVD-file (data.qvd) and I have to separate data by month_year and store it into QVD (data_$(month_year).qvd) automatically.

But I can't get how to automatize it.

Fields for excapmle:

Company;

Transaction date;

Transaction No;

Amount

Please help to make an automatic separation.

Thanks a lot!

Hello,

I have this load script for one of my app in Qliksense.

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LastName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.

User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LasrName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

WHERE Fiscal_Year >= (YEAR(GETDATE())-2);   //to get only year 2024 and 2023,2022//

It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021

I am not sure what I am missing. Could someone please help me with this?

thank you!

Hi,

In the Qlik app 'License Monitor', all my users on the 'User Detail' sheet are UNKNOWN.

I have looked in the load editor script and I can see that there is a mapping table to retrieve the user's name. Looking at the information the responses returned for both tables, the user id's do not match leading to the default value in the ApplyMap.

Does anyone has any idea why this may be happening?

Thanks,

Amy