Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 255,324 members
  • 4,771 online
  • 2,036,771 posts
  • 153,367 Solutions
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT

Welcome to Qlik Community

Recent Discussions

  • forum

    Talend Studio

    Configuring an HTTPS connection with Talend on Linux server

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

    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:

    williaml_0-1751367117030.png

    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?

    Show Less
  • forum

    Data Movement & Streaming

    Qlik Cloud Data Integration - Frequency of BICC extracts from Oracle Fusion

    Hi Support, With regard to the Oracle Fusion connector in Qlik Cloud Data Integration, since the connector uses BICC to connect to the Fusion database... Show More

    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

    Show Less
  • forum

    App Development

    Conditional Count if for entire column

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

    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.

    IDCreatedClosedCounter
    101.01.202002.01.20200
    202.01.202002.01.20201
    303.01.202005.01.20202
    404.01.202004.01.20202
    505.01.202005.01.20204

     

    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

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Task Fails with “Not Enough Storage” on MySQL Insert – Param#003 ...

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

    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:

    • Source: Oracle (Supplemental Log On, Table PK exists, ARCHIVELOG On)
    • Target: MySQL
    • Problematic column: DOCUMENTS (CLOB)
    • LOB Setting: Limit LOB to 20480KB ~ 20MB
    •  

    AbdullahMastan_0-1751970396571.png

     

    The error says "(size: 41943041000 bytes)" that is approx 40GB... but why?

     

    Show Less
  • forum

    App Development

    Pivot table - Unable to sort multiple measures in QlikSense

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

    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.

    Karim_Khan_0-1750317811627.png

     

    Regards,

    KK

    Show Less
  • forum

    App Development

    Binary load doesn't work with app name

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

    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'm running an app from my work environment
    • There's an app in a stream, called Klantmonitor, so no special characters involved.
    • I can't find a file on server named Klantmonitor.qvf, I do see a file with the app id in folder d:\qlikshare\apps.

    I tried:

    • Binary Klantmonitor.qvf;
      Results in: No qualified path for file: ***
    • Binary [lib://Qlik Sense Apps (binary load source)/Klantmonitor.qvf];
      Results in: Filesize for D:\\Qlikshare\Apps\Klantmonitor.qvf failed: The system cannot find the file specified.
    • Binary D:\\Qlikshare\Apps\Klantmonitor.qvf;
      Results in: This statement only works with lib:// paths in this script mode.
    • Binary [076d5faf-3e50-47da-9cc1-7c7a1a55db39];
      Results in: No qualified path for file: ***

    Any other ideas?


    Grt,

    Suzanne

    Show Less
  • forum

    Talend Studio

    Connection a Talend Job to a Microsoft Sharepoint

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

    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

     

     

     

    Show Less
  • forum

    Qlik NPrinting

    Nprinting variables and MasterData reload problem

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

    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:

    glebret_0-1750776886314.png

    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:

    glebret_1-1750777106825.pngglebret_2-1750777175918.png

    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

     

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    How to create Custom roles for depreciated users in Qlik cloud?

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

    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

     

    Show Less
  • forum

    App Development

    Monthly Customer retention Chart in qlik

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

    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
    DATE01/01/202502/01/202503/01/202504/01/202505/01/202506/01/202507/01/202508/01/2025
    01/01/202510096959493929180
    02/01/202510197969594939281
    03/01/202510298979695949382
    04/01/202510399989796959483
    05/01/2025104100999897969584
    06/01/20251051011009998979685
    07/01/202510610210110099989786
    08/01/2025107103102101100999887

     

    Thanks in Advance,

    Regards,
    Poojashri

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

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.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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!