Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 243,674 members
  • 4,788 online
  • 2,026,938 posts
  • 152,502 Solutions
Announcements
The New Qlik Learning Experience is Here! GET STARTED

Welcome to Qlik Community

Recent Discussions

  • forum

    Application Automation

    Fetching response from a triggered automation in async mode using API

    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 f... Show More

    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:

    • We need to trigger an app automation programmatically (e.g. via an API call) and pass some parameters to the automation
    • The automation may run anywhere from 10 sec to a few min depending on the input parameters
    • We need to fetch the response from this automation programmatically (e.g. via an API call, same as above or a different one)

    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.

    Show Less
  • forum

    Qlik Replicate

    Table {tablename} (ID '1070991242') does not exist anymore. Failure in approvin...

    QlikReplicate from Win2019, using MSReplication. I am getting this error message on two of the 100 tables that I am replicating from: 00022488: 2025-0... Show More

    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?

     

     

     

     
    Show Less
  • forum

    App Development

    Compare if the values in two date columns are the same using an IF statement

    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 formatte... Show More

    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.

    Show Less
  • forum

    Women Who Qlik

    Help Qlik Celebrate International Women's Day! 💪

    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” t... Show More

    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! 

    womenhistorymonth.png

     

    Together, lets #AccelerateAction to speed up the rate of progress for gender equality.

    Show Less
  • forum

    Qlik Replicate

    Qlik stop task is very slow

    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... Show More

    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.

    Show Less
  • forum

    QlikView App Dev

    conditionnal sum

    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 , ... Show More

    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.

    Capture d’écran 2.png

     

    the results is ok , in a straight table  : (had to change total properties from auto to Sum ) Capture d’écran 2.png

    Thank you thousand time for your help

     

     

    Show Less
  • forum

    QlikView App Dev

    Proper Case

    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 th... Show More

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Exporting Qlik Script (QVS) with Powershell QSefW

    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... Show More

    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?

     

     

    Show Less
  • forum

    Visualization and Usability

    Email Subscription for Updated Sheets

    Our current development process is to duplicate a sheet and work off the duplicated sheet while maintaining the public sheet. This allows a version co... Show More

    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?

    Show Less
  • forum

    Deployment & Management

    Is it possible rotate the Qlik Sense PostgreSQL password?

    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 passwor... Show More

    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.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!