Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Recently, i have been trying to implement and following were the Result anticipated:
Expected Result:
GSKG Artikel | |
60 82xx xxxx xxx | 103002 |
60 84xx xxxx xxx | 103002 |
60 90xx xxxx xxx | 103002 |
60 8700 0001 001 | 103002 |
60 8900 0082 001 | 103002 |
60 8900 0082 002 | 103002 |
60 8900 0082 003 | 103002 |
60 8900 0082 004 | 103002 |
GSKG all Artikel | 103001 |
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.
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.
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
I want to trigger a Qlik Cloud App reload when an external process is finished. This process can execute a PowerShell script. Is there a method in which I can trigger an App reload using a Powershell script? How can I connect to the App reload using an API Key?
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.
Hello
We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.
We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.
The filer was loaded correctly (and unexpectedly !)
We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target
Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?
Lt us know
Regards
Alessandro Ferrario
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.
Hi Qlik experts,
I created several Qlik Sense apps at Qlik Sense Server, and also uploaded several Qlik Sense apps to Qlik Sense Server.
The Qlik Sense Server will terminate.
How could I backup all my Qlik Sense apps at Qlik Sense Server? So, I will not lose my Qlik Sense apps.
Thanks for your help!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!