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 

I would like answers to the following three questions about the GetTaskDetails API:

1. The commit_change_records_count is described in the documentation as "The number of COMMIT change records."
   Could you please provide more details about this field?
2. I couldn't distinguish between commit_change_records_count and applied_records_comitted_count.
   Could you explain the meaning of applied_records_comitted_count?
3. In what situations could this kind of response result occur?
   'cdc_transactions_counters': {'commit_change_records_count': 16126, 'rollback_transaction_count': 0, 'rollback_change_records_count': 0, 'rollback_change_volume_mb': 0, 'applied_transactions_in_progress_count': 0, 'applied_records_in_progress_count': 0, 'applied_comitted_transaction_count': 0, 'applied_records_comitted_count': 0, 'applied_volume_comitted_mb': 0, 'incoming_accumulated_changes_in_memory_count': 0, 'incoming_accumulated_changes_on_disk_count': 0, 'incoming_applying_changes_in_memory_count': 0, 'incoming_applying_changes_on_disk_count': 0}

          ■What I confirmed by checking the response is:

          ・total_latency is 00:00:00, indicating no latency.
          ・All incoming_XXX values are 0, suggesting no unapplied changes.
          ・commit_change_records_count is 16126, while applied_records_comitted_count is 0, indicating a discrepancy.

          ■The status of the task when this response is returned
          ・The task is running when GetTaskDetails is executed ('state': 'RUNNING').
          ・There are no errors or warnings in the task log.
          ・SAP Application source is used (with SAP HANA as the backend using trigger-based CDC), and no filters are set on the task.

Hi Support Team,

There are 「Advanced Run Options」 available for Qlik tasks.
You can select the following in 「Tables are already loaded. Start processing changes from:」.

・Date and Time
・Source change position

In the REST API RunTask there is an option "RESUME_PROCESSING_FROM_TIMESTAMP",
I think this is the same function as 「Date and Time」.

Please tell me how to specify 「Source change position」 as a RunTask option.

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/CurlAPI/api_runTask.htm