Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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

    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

    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
  • forum

    App Development

    Can we use Qliksense buttons as a measures

    I am migrating Qlikview app to Qliksense, I have many table charts with same dimensions and different expression. Can i create one table chart and cre... Show More

    I am migrating Qlikview app to Qliksense, I have many table charts with same dimensions and different expression. Can i create one table chart and create multiple buttons with different expression measure so that the one table filter out each time we use different button. Is it possible in qliksense?

    Please help, thanks in advance. @qliksense Qlik Sense Business 

    Show Less
  • forum

    Application Automation

    Contains third-party blocks ??

    Since a few days we see the message "Contains third-party blocks" on some automations we have.  It looks like this message is created when there is an... Show More

    Since a few days we see the message "Contains third-party blocks" on some automations we have. 

    It looks like this message is created when there is an update available of 1 or more blocks. We think this message causes confusion and isn't related to the real "problem" which is kind of ugly. 

    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!