Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there - We are seeking assistance in implementing our use case with an app automation.
TL;DR Question: Is there any way we can fetch the response from triggered automation running in asynchronous mode using any of the available API endpoints?
If the answer is not, are there any other options to accomplish our use case below?
Our Use Case:
So far we set up a triggered automation and we call it via its dedicated Webhook URL. We are able to pass our required parameters in the URL and access them in the automation. The same API call gives us the expected response upon completing the automation.
This is described in more detail here: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/working-with-automations/working-with-webhooks.htm
Where it gets tricky is that we often run into a limit of 90 seconds for executing a triggered automation. Our research shows that the only option to overcome this limit is to switch to executing the automation in asynchronous mode. When we do that, our original API call starts to return the execution job status and ID instead of the actual response. It makes sense given that the automation is now first put into a queue and then executed as needed. When we run the automation in async mode via UI, it eventually gives us the expected response.
Where we struggle is with getting the eventual response from the automation via API/URL. Is there any way we can do that using the available API endpoints? Our hope is we can get the result from API using the execution job ID but we were not able to find the appropriate API endpoint.
QlikReplicate from Win2019, using MSReplication.
I am getting this error message on two of the 100 tables that I am replicating from:
00022488: 2025-02-10T19:21:34 [SOURCE_CAPTURE ]W: Table '{tablename}' (ID '1070991242') does not exist anymore (sqlserver_log_queries.c:4009) 00022488:
2025-02-10T19:21:34 [SOURCE_CAPTURE ]W: Failure in approving table full logging setup for {tablename} (sqlserver_log_utils.c:2258).
I have turned on Verbose logging on SOURCE_CAPTURE, but no error message or additional helpful info provided. The tables ARE do exist, but they are NOT in the MSArticles table. This means to me that replicate can't load these tables, but it was able to load the other ones.
Any ideas? Has anyone seen this?
Hi All,
I am still new to Qlikview.
I'm trying to compare two dates to display either a "Y" or "N" based on whether they are the same. I have formatted both date fields, but I’m always getting "N" in the result.
I tried the DATE and FLOOR function to remove the timestamp from both fields:
DATE([RECORDED_TIME], 'MM/DD/YYYY') as Recorded_Date
FLOOR([RECORDED_TIME]) as Recorded_Date_Floor
DATE([SURGERY_DATE], 'MM/DD/YYYY') as Surgery_Date
FLOOR([SURGERY_DATE]) as Surgery_Date_Floor
Then, I applied the following calculation to compare the dates:
IF(Recorded_Date = Surgery_Date, 'Y', 'N')
IF(Recorded_Date_Floor = Surgery_Date_Floor, 'Y', 'N')
However, this still doesn't work as expected. Could someone please guide me and let me know if I'm making any mistakes here? Is there a sample or best practice I could follow to compare dates correctly?
Thanks in advance for your help.
Hello, Women Who Qlik community!
International Women’s Day is coming up on March 8. Every year, International Women’s Day has a theme and a “pose” that people can take pictures of themselves to join the conversation. This year the theme is Accelerate Action.
We are inviting our Women Who Qlik to submit pictures doing the 2025 pose (as pictured below). Our social media team may use the photos on International Women’s Day to help raise awareness, celebrate, and support our amazing Women Who Qlik.
If you'd like to participate, please email your photos to QlikNation@qlik.com by February 28. Feel free to invite female colleagues or allies to join you- or gather together for a group photo! Please note any photos submitted may be used on Qlik social media. If you are a Qlik Nation member, you can also submit via this challenge.
We can't wait to see your poses!
Together, lets #AccelerateAction to speed up the rate of progress for gender equality.
Hi Folks,
We are trying to add/remove tables programmatically to a running task. Basically we are 1. stopping the task 2. exporting the task definition 3. connecting to sql server and dropping the table article(in case of remove) 4. importing the task again with modified table list 5. starting the task again.
We observe that the stop task is taking around 30 to 60 seconds before the task is truly stopped. Starting the task before in this time is not failing. But at the same time it is not starting the task either resulting in wrong information being propagated to our upstream.
Question:
1. Is it possible to minimize this latency of 30 to 60 sec that the top task is taking.
2. Is there a way we can implement a callback when the task is stopped. Currently we are polling every 10 seconds to see if the task has truly stopped before giving up entirely after 10 trials.
3. If the above 2 options are not possible, what should be an ideal wait time before the application gives up the start task.
Any help in this regards will be deeply appreciated.
Hi Experts ,
Once again I need your help ! the case may look simple but I can't have the expected results .
In expression D ,in the table below , I'd like to have the total where expression C < 39.
As you can see , the columns 2 and 3 in the expression D are excluded which is correct , but still haven't found out why the total don't show up. I tried to sum (aggr ( D expression,... ) but still.
the results is ok , in a straight table : (had to change total properties from auto to Sum )
Thank you thousand time for your help
Hi,
Is there something like the excel Proper function I can use in QV?
I have fields where our system shows all stores in UPPERCASE, I want to change them all to Proper Case. I've played around with the Force statement but this seems to be for Field Names, I just want to change the field values.
Like I would use the number function...
Regards,
Gerhard
Hi,
A Customer of ours wants to archive their Qlik Scripts they are using via Powershell.
He found some documentation which says it should be possible via the following endpoint.
https://<qlik-server>/qrs/app/<app-id>/script?xrfkey=<xrf-key>
But when I run a script in powershell for this endpoint I'm receiving a 404 error.
Listing apps, Tasks etc. is working, but the script part gave me a error so i'm in doubt if this is a valid endpoint
Does anyone ever made a solution like this?
Our current development process is to duplicate a sheet and work off the duplicated sheet while maintaining the public sheet. This allows a version control process that we can revert back to the original. We also have staff starting to use the subscription email functionality. We noticed that when we publish the updated duplicated sheet and archive their subscribed one the email subscription doesn't get updated. It'll error out because the sheet cannot be found. Is there any efficient way to manage either version control of sheets to maintain the subscription or quickly update subscriptions with the new sheet?
Hi All,
We are installing Qlik Sense using a silent script and we are able to do it. Unfortunately, my organization does not permit the use of passwords that are known to either the developer or those who installed it. The password will be available at the center location and rotates every six or 12 months. If the password rotates on the center location, we are looking for a script to update the password for the PostgreSQL database.
Is there any script to update/reset the password for the Postgres database using command prompt or PowerShell?
This is super urgent if it is possible please share the script or suggest.?
Thank you.
We are thrilled to announce that the new Qlik Learning is now live and ready for you!
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
From product innovation, to technical tips and tricks, to real world success stories, Qlik Connect offers learning opportunities for all levels.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!