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

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.

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 

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.