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!

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.

Bonjour,

Je cherche à calculer la DN (Distribution Numérique) d'une référence par rapport à son groupe d'appartenance.

Je dois donc compter le nombre de client qui n'ont pas un CA à 0€ pour ma référence ce que j'obtiens bien avec 

Count({<Client = {"=Sum(CA) <> 0"}>} DISTINCT Client)

En revanche, j'ai maintenant besoin d'obtenir le nombre des clients qui ont un CA différent de 0€ pour l'ensemble des références appartenant au même groupe que ma référence sélectionnée.

Par exemple REF1, REF2, REF3 sont dans le groupe A et je veux donc savoir en sélectionnant REF1 le nombre de clients qui commandent soit REF1, soit REF2, soit REF3 donc qui commandent parmi groupe A.

Il me faudrait quelque chose comme groupe={groupe de REF1} et exclure la REF1 sélectionnée avec REF=

Je vous remercie par avance de votre aide.

Hello Everyone,

Recently, i have been trying to implement and following were the Result anticipated:

Expected Result:

The query that i wrote was:

if((Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6082 and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6084
and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1) =6090 and If(WildMatch(GSKG_Zufu_Artnum,6087000001001),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082001),
If(WildMatch(GSKG_Zufu_Artnum,6089000082002),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082003),103002,
If(WildMatch(GSKG_Zufu_Artnum,6089000082004),103002,Text(103001))))))) as Zufu_WeBuDaten_Leer_E1MARCM_PRCTR,

While loading the Data, it fetches an Error in these lines. 

Could anyone please go through once my query and Required Result and suggest me or clarify me the mistake i am making?

Thanks in advance.

Hi,

is here some option how to set for analyzer capacity license user different Session inactivity timeout (10 min) than for user with professional license (default 30 min)?

Explanation:

I need it for our case when app is reloaded each 15 min and app reload extend session inactivity timeout. If I left the capacity license to reload for 30 minutes, the license would be used up if the user did not log out. Reload is considered as a user activity.

Is here some way how to deal with it?

User with professional license doesn´t want to be logged out every 10 minutes.

Thank you for ideas

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