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,

I have a bar chart showing sales volume per quarter (quarters on the x-axis)

currently the chart is fixed to always show the last 10 quarters, but ideally I would like to make it flexible, so that the users can select the quarters visible on their own, but when opening the sheet initially I would like to have the last 10 quarters selected automatically..

As the FYFQ field is a string like FY23-Q1, I additionally created a FYFQ_Row field which is a number count. Meaning 1 is the oldest FYFQ available and the highest number is the most recent FYFQ.

currently the chart is fixed to show always the last 10 quarters with the following dimension "if(FYFQ_Row > v_maxFYQ-10 and FYFQ_Row <= v_maxFYQ, FYFQ)" where "v_maxFYQ is defined as max(FYFQ_Row)

this works perfectly fine.

but my question is now the following: 
when changing the dimension to "FYFQ" obviously the chart will show all quarters available.
I know that through Sheet Actions I can add actions that are performed on opening of the sheet, like select a specific field value, etc.

But is it possible to somehow make the selection from above dimension on sheet opening. Meaning can I automatically select the last 10 quarters in the FYFQ field on sheet opening?

Thanks for your help.

Liebe Community,

Ich habe ein Punktediagramm mit x - y Werten sowie einer definierten Größe pro Datensatz. Je nach gefilterter Kategorie scheint es jedoch so, dass sich die Bubblegröße (trotz fester Skalierung) an die gefilterte Menge anpasst und somit rein visuell unterschiedliche Größen aufweist.

Ist das Problem hier bekannt und wisst zufällig ob sich das lösen lässt?

Vielen Dank vorab

Hi Support Team,

I checked the status of the task in Enterprise Manager's Message Center.

When executing the 「FULL+CDC」 task, TYPE was output in the following order.
・TASK_START
・TASK_FULL_LOAD_STARTED
・TASK_FULL_LOAD_FINISHED

After stopping the task and restarting it with "Resume", the TYPE was output in the following order.
・TASK_STOP
・TASK_START
・TASK_FULL_LOAD_STARTED

Since it is 「Resume」, FULLLOAD will not be executed,
but 「TASK_FULL_LOAD_STARTED」 was displayed in the Message Center.

I have a question about the TYPE 「TASK_FULL_LOAD_STARTED」 at this time.
・Why is 「TASK_FULL_LOAD_STARTED"」 output even when I select 「Resume」？
・For what kind of operations will 「TASK_FULL_LOAD_STARTED」 be output？

I am trying to send a request body to tRestClient in the below format

{"x" : [1,2,3], "y" : [] }

I am using txml map to prepare the body and send a request, it is being sent as  string type not as a list type

{"x" : "[1,2,3]", "y" : "[]" }

Hi, 

I was checking if we could install NPrinting, Alerting and Geo Analytics on the same server. couldnt find any articles related to it. I know that Qlik doesnt support QS and NP on a same server but not sure of NP and Qlik Alerting on the same server. 

Thanks in Advance

Qlik NPrinting Qlik Alerting Qlik GeoAnalytics 

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.