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: 
  • 278,343 members
  • 21,257 online
  • 2,051,526 posts
  • 155,087 Solutions
Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect

Welcome to Qlik Community

Recent Discussions

  • forum

    Water Cooler

    What Customers and Partners Can Expect from new Qlik CEO Saugata Saha

    A clear vision, candid communication, strong execution, and a focus on creating value together.  In his first interview as Qlik CEO, Saugata Saha shar... Show More

    A clear vision, candid communication, strong execution, and a focus on creating value together. 

    In his first interview as Qlik CEO, Saugata Saha shares what customers and partners can expect from his leadership and why collaboration across the Qlik ecosystem will be central to the opportunity ahead. 

    In the full conversation, Saugata also discusses: 

    • What drew him to Qlik  
    • His perspective on data and AI  
    • The importance of Qlik’s customers and partner ecosystem  
    • His priorities for the first 90–100 days  

    Watch the full conversation:

     

    As Saugata shares, the future is bright! To help you look ahead in style, we're sending Qlik sunglasses to our Qlik Community members 😎 

    Please join us in welcoming Saugata to Qlik and the Qlik Community. Share your reactions and thoughts with Saugata below, and we will send you a pair of Qlik shades (while supplies last). 

     

     

    Show Less
  • forum

    App Development

    Current year vs previous year cumulative sales

    Hi all, good evening, I need to compare the cumulative sales between a year and the year before. This for many years stored in my database. The sales ... Show More

    Hi all, good evening,

    I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

    The sales had already been normalized by the month of each year.

    This is the expression I created to generate the information for each year:

    Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

    YEAR/MONTH SALES YEAR QTY
    (other year months) ... ...
    2026/01 2024 1
    2026/02 2024 10
    2026/03 2024 25
    2026/04 2024 8
    2026/05 2024 14
    ... ... ...
    2026/01 2025 0
    2026/02 2025 3
    2026/03 2025 12
    2026/04 2025 11
    2026/05 2025 7
    ... ... ...
    2026/01 2026 4
    2026/02 2026 5
    2026/03 2026 8
    2026/04 2026 12
    2026/05 2026 20

     

    And this is the generated graphic:

    andrelfg_0-1786559771694.png

     

    What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

    I have already tried many solutions here in the topics, but I couldn't get the right result.

    For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

    Thanks in advance for any help.

     

    Show Less
  • forum

    Reporting Service & Alerting

    Reporting through Automation

    In Qlik Sense, I have a sheet containing a Filter Pane with a Region field and a Straight Table displaying data based on the selected Region.The Regio... Show More

    In Qlik Sense, I have a sheet containing a Filter Pane with a Region field and a Straight Table displaying data based on the selected Region.

    The Region filter contains three values:

    • Region 1
    • Region 2
    • Region 3

    I need to create an Excel report using Qlik Automation with the following requirements:

    1. Only one Excel workbook should be generated.
    2. The workbook should contain three separate sheets:
      • Region 1
      • Region 2
      • Region 3
    3. Each sheet should contain only the data from the Straight Table corresponding to that particular Region.
    4. The automation should dynamically apply each Region as a filter, retrieve the filtered Straight Table data, and write it to the respective Excel sheet.

    Question: What Qlik Automation blocks and configuration should be used to achieve this requirement?

    Show Less
  • forum

    App Development

    SFTP connection with a non standard port

    per default qlik supports only ports 22 and 2222 for SFTP connections.i created a connection to a host with port 22 then i tried to edit the port in q... Show More

    per default qlik supports only ports 22 and 2222 for SFTP connections.

    i created a connection to a host with port 22 then i tried to edit the port in qmc connection string to 443.

    geting the error: The following parameter validation errors were found: sftpPort: Port is invalid.

     

    I see no reason why a SFTP service should not be able to run any ports.

    Is there a way how to workaround this?

    Show Less
  • forum

    Integration, Extension & APIs

    Custom Pivot Table

    Good Day all, Please let me know if this is not the correct location for this question.Does anyone have/built a pivot table extension where I can move... Show More

    Good Day all,

     

    Please let me know if this is not the correct location for this question.

    Does anyone have/built a pivot table extension where I can move the totals to the bottom of the pivot table?

    I know this is a "cheap" request, but I have a client that is really difficult on this.

    Show Less
  • forum

    Talend Studio

    JSON fied in a CSV file

    Hello y'all, I've got a regular .csv file, with around 30 regular columns. However, a couple of columns are JSON text. I would like to parse the JSON ... Show More

    Hello y'all,

    I've got a regular .csv file, with around 30 regular columns. However, a couple of columns are JSON text.

    I would like to parse the JSON text and get some extra columns from it.

    I've tried to use a tExtractJSONFields, but there are two flaws:

    - the component seems to be expecting a full JSON input, not a JSON column among regular string-type columns

    - I hardly know anything about Json paths and Json queries 

    The JSON column is called 'jugement', one of the JSON property I need from it is called 'complementJugement', so I've used '$.jugement' as the Jsonpath query and 'complementJugement' as the Json query mapped to a new schema column. I got this error message:

    Expected to find an object with property ['jugement'] in path $ but found 'java.lang.Integer'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.

    Can anyone help me with this issue?

    Thanks in advance

     

    Show Less
  • forum

    QlikView

    How to get this date stored as text as a regular date field in QlikView?

    Hi,attached is the data source file from which I can't get a regular date field from the DateDMMMYYYY column in QlikView using this standard function ... Show More

    Hi,

    attached is the data source file from which I can't get a regular date field from the DateDMMMYYYY column in QlikView using this standard function or even  date#():

    date(DateDMMYYYY,'d.MM.YYYY') as DateProduced;

    Any help is very welcome.

    Thank you 

    Show Less
  • forum

    Connectivity & Data Prep

    How to extract data from Instagram

    Hi friends,I have been using Qlik web connector for Facebook, Twitter and Youtube data but can't find a connector for Instagram.Is there a way to extr... Show More

    Hi friends,

    I have been using Qlik web connector for Facebook, Twitter and Youtube data but can't find a connector for Instagram.

    Is there a way to extract the data from Instagram in Qlik Sense using any other connector. If yes, Can someone please guide me.

    Looking forward for positive replies.

    Thanks and Best Regards

    Show Less
  • forum

    Reporting Service & Alerting

    App Failure Alert in Mail to Users on Qlik Cloud

    Need to alert users regarding app reload failures on mail in automated way.Any automation or any other way to implement this on Qlik cloud? 
  • forum

    Talend Studio

    Problem with reference class TaCoKitCache

    I have a problem when opening a project on my studio.  When opening some (but not all) projects I get the following error : Generation Engine Initiali... Show More

    I have a problem when opening a project on my studio. 

    When opening some (but not all) projects I get the following error : 
    Generation Engine Initialization in progress...
    "Can't find service reference for class 'org.talend.sdk.component.studio.metadata.TaCoKitCache'"

    This error prevents me from opening any jobs on the Talend Studio
    The error looks like it's "spreading" as I now have new project that I can't access too 

    What I've tried so far : 

    Deleting the workspace foder
    Reinstal Talend Studio (8.0.1 R2026 - 01)

    Any idea ? 

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

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

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

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

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

AI Reality Tour

Zurich

Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.