Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am new to Talend and I have given a task to connect Talend to an API which require in HTTPS connection.
I have download the certificate on place it in the cert store and I have configure Talend using the following setup:
It works on Windows device but I will need to use it in Linux environment.
What I have done so far is import it to the keystore in Linux server and change the configure above but it wont connect.
Next what I have done is copy the cacert file from windows machine to Linux server and place it in /etc/pki/tls/certs/cacerts and I have update the path and the password but it sill not able to connect.
Can I ask if someone had able to connect using Linux server?
Hi Support,
With regard to the Oracle Fusion connector in Qlik Cloud Data Integration, since the connector uses BICC to connect to the Fusion databases, is there an indication of how frequently extract jobs run in BICC to capture the changes in the Fusion tables?
Thanks,
Nak
Hi all,
I want to each row to calculate the number of columns, which match the following criteria:
(1) the created date has to be <= the created date of the specific line
(2) the close date has to be <= the created date of the specific line
Example:
For ID = 4, there are 2 rows, which match the criteria (ID 1 + ID 2). ID 3 does NOT match the criteria, since the close date is after the created date of ID 4. Therefore, the counter should not count this lins.
ID | Created | Closed | Counter |
1 | 01.01.2020 | 02.01.2020 | 0 |
2 | 02.01.2020 | 02.01.2020 | 1 |
3 | 03.01.2020 | 05.01.2020 | 2 |
4 | 04.01.2020 | 04.01.2020 | 2 |
5 | 05.01.2020 | 05.01.2020 | 4 |
I know that I can word with rangesum(peek(, but I do not get this working, taking into account that I have the filter criteria which I need to get into this formula.
What I started with:
RangeSum(Above(TOTAL Sum(if(CreatedDate<=CreatedDate and CloseDate<=CreatedDate, Counter)), 0, RowNo(TOTAL)))
Can anybody help me?
Thanks
Florian
Hi Qlik Community,
I'm encountering a critical issue while running a Qlik Replicate task from Oracle to MySQL. The task fails during the data load phase with the following error:
Stream component 'st_1_agm-mysql-dest' terminated Stream component failed at subtask 1, component st_1_agm-mysql-dest Error executing data handler Failed to get statement, func: insert row handler Failed to prepare statement 'INSERT INTO `agmdb`.`EMPLOYEES`(`EMP_ID`,`EMP_NAME`,`DOCUMENTS`) values (?,?,?)' Failed to allocate array for parameter 'Param#003' in statement 'INSERT INTO `agmdb`.`EMPLOYEES`(`EMP_ID`,`EMP_NAME`,`DOCUMENTS`) values (?,?,?)' (size: 41943041000 bytes) Not enough storage is available to process this command. (apr status = 720008)
Context:
The error says "(size: 41943041000 bytes)" that is approx 40GB... but why?
Hi Folks,
Hope you're doing well !!
I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of qliksense.
Is there a way to do customize sorting of pivot tables in Qlik sense so that measures should show in descending order, I have tried both sort by first measure and sort by expression but still lagging to get this.
Regards,
KK
Hi,
In our dashboard we used the binary load statement, followed by an app id. A couple of days ago we've upgraded our qlik sense environment and this isn't working anymore. We need to use the appname, followed by extension qvf..
However, I can't find those "named" qvf files on our server. We only have the files with an AppId as identifier.
For sake of completeness, I've added the things I've tried so far:
I tried:
Any other ideas?
Grt,
Suzanne
Hello everyone,
I'm trying to create a Job to get files from a Microsoft Sharepoint and also to put files in certain folders of the Sharepoint.
I'm using tHTTPClient to do this, but I'm having a hard time with it.
To get files from a certain directory, I am using basic authentication type (username and password), using the GET HTTP method, setting up a directory to save on my local disk, checking the "download attachments" checkbox and filling in the Base URL and the Path.
But I either get a 404 - NOT FOUND or a 403 - FORBIDDEN error as a return body.
Can someone, please, let me know how to go about it?
I can really use some help here,
Rui
Hi,
I need some help in Nprinting.
I have 2 issues.
Originally, my clients developped an app with 12 tables.
Each tables contained a bunch of dimensions which were all identical and 2 measures which were almost identical. The only thing that changed was the content of the set analysis.
Thus, in order to simplify everthing, I created 2 master measures which contain set analsysis and the content of the set analylsis will change depending on a variable value which is changed by a button.
For instance, Button 1 set variable value to 1, button 2, value to 2,..
The idea is to have only 1 table and 2 measures to maintain and It works great in qlik sense.
Then in Nprinting, I created 12 filters such as this one:
I tried with and without the evaluate options checked.
I need to create an excel report with 1 sheet per table.
Thus, I called my table 12 times in my report and for each one, I define the filter matching the variable value:
I have 2 problems:
1. It works great for the 1st tables but all the other ones fail
2. In my report, I create a formula ReloadTime() to show the reload time of the QS app.
But ,from the moment, I run the report once, as mentioned before, it fails and then if I try to run it a second time, Nprinting mentions that there is a problem with the formula reloadtime(). This error stops if I reload the masterdata.
Can anyone help me on this?
Thanks
Gerald
Hi,
We need to replace the roles & Permissions on Qlik cloud. Can anyone explain which permissions we need to include in the custom roles for depreciated roles?
The document says we need to replace it with a custom role, but there does not seem to be a valid option to do it.
We tried creating new custom role:
Name: API Create
Description: Allow users to Manage API keys
Got struck at Permissions.
Regards,
Pavan Aruva
Hi All,
I have a source table that contains player activity details with the following columns:
Date, PlayerID, and GameID.
I’m trying to analyze player retention — specifically, I want to identify how many players who started playing on a given date have continued playing in subsequent months.
My goal is to generate an output table in Qlik with the following structure, where each row represents the cohort of players who started on that date, and each column shows how many of them remained active in the following months:
Retention Month | ||||||||
DATE | 01/01/2025 | 02/01/2025 | 03/01/2025 | 04/01/2025 | 05/01/2025 | 06/01/2025 | 07/01/2025 | 08/01/2025 |
01/01/2025 | 100 | 96 | 95 | 94 | 93 | 92 | 91 | 80 |
02/01/2025 | 101 | 97 | 96 | 95 | 94 | 93 | 92 | 81 |
03/01/2025 | 102 | 98 | 97 | 96 | 95 | 94 | 93 | 82 |
04/01/2025 | 103 | 99 | 98 | 97 | 96 | 95 | 94 | 83 |
05/01/2025 | 104 | 100 | 99 | 98 | 97 | 96 | 95 | 84 |
06/01/2025 | 105 | 101 | 100 | 99 | 98 | 97 | 96 | 85 |
07/01/2025 | 106 | 102 | 101 | 100 | 99 | 98 | 97 | 86 |
08/01/2025 | 107 | 103 | 102 | 101 | 100 | 99 | 98 | 87 |
Thanks in Advance,
Regards,
Poojashri
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms.
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space.
A one-day focused event designed to give you practical strategies and real-world use cases for transforming data, analytics, and AI.
Salesforce's acquisition of Informatica brings change. Explore options for a smoother transition.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
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!