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: 
  • 263,870 members
  • 5,136 online
  • 2,045,342 posts
  • 154,217 Solutions
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Welcome to Qlik Community

Trending Forums

Recent Discussions

  • forum

    App Development

    Linking fact table to dimension table 2 ways

    I am relatively new to the Qlik universe and am setting a data model up in Qlik Sense, but really struggling to get it linking correctly, without circ... Show More

    I am relatively new to the Qlik universe and am setting a data model up in Qlik Sense, but really struggling to get it linking correctly, without circular references.

    The tables/fields in question are:

    Sales - ProductID, SalesSource, CustomerID, SalesValue

    Product - ProductID, CategoryLevel1, CategoryLevel2

    Targets - SalesSource, CustomerID, CategoryLevel1, CategoryLevel2, SalesTarget

    The problem is with linking both Sales and Targets to Product via different fields when the 2 are linked themselves (or in a concatenated fact table, as I have it at the moment). I've tried various versions of link tables and synthetic keys, but can't get it working correctly.

    Any suggestions/pointers please?

    Show Less
  • forum

    Talend Studio

    [2025-08] tHttpClient - "Returned content: Download file only" option not visibl...

    Hello Community, I’m currently working with Talend Studio 2025-08, and I’ve noticed that in the tHTTPClient component, the “Returned content” dropdown... Show More

    Hello Community,

    I’m currently working with Talend Studio 2025-08, and I’ve noticed that in the tHTTPClient component, the “Returned content” dropdown does not show the optionDownload file only

    According to the Talend documentation, this setting should be available (alongside Body, Headers and body, Status, headers and body) and is used together with “Download attachments” to download only the response file without returning the payload to the main flow

    However, in my environment, the list only contains:

    • Body
    • Status, headers and body

    No “Download file only” entry appears

    What I’ve checked so far:

    • The tHTTPClient component is available in my palette.
    • I can see the “Download attachments” checkbox in the Basic settings
    • The documentation (for 8.0 and later) still mentions “Download file only”.

    My question:

    How can I activate or enable the “Download file only” option in the Returned content list?

    Is it controlled by a specific feature flag, component version, or patch level (e.g., introduced after a certain R2025 build) ?

    Context:

    I have migrated from 2024-03 to 2025-05, and I am now migrating to 2025-08. I’m downloading files larger than 120 MB, and when I try to download a single file (around 120 MB), I get a Java Heap Space error. I don’t want to increase the maximum allocated Java memory yet—I’d like to try other options first, because a 120 MB file should not require more than 1 GB of memory :

    Exception in component FRK_DOWNLOAD_GRAPH_FILES_1_tHTTPClient_3 (tetzdzf)

    org.talend.sdk.component.api.exception.ComponentException:

    (java.lang.OutOfMemoryError) Java heap space

     

    Thank you in advance for any clarification or guidance!

    PaSympa_0-1762271201043.png

     

    Show Less
  • forum

    App Development

    dynamic valuelist

    HelloI got a pivto table with Fiscal_Year as a dimensionso we have the following values:202320242025I created another dimension as follows:ValueList(d... Show More

    Hello
    I got a pivto table with Fiscal_Year as a dimension
    so we have the following values:
    2023
    2024
    2025

    I created another dimension as follows:
    ValueList(dual('Actual',1), dual('Budget',2), dual('FCS#1',3) , dual('FCS#2',4))

    so these values will be repeated for each fiscal year above
    however what I want is that:
    I have 3 filter panes each in an alternate state:
    so if user selects Actual in the first filter pane then under 2023 I should only display Actual and thus calculate the actual values
    if in the second filter pane the user selects Actual, and Budget then under 2024 I should display both actual, and budget and thus calculate the actual and budget values repsectively
    ...
    kindly advise on how to accomplish this or if there is another approach via which I can accomplish this requirement

     

    Show Less
  • forum

    Qlik Replicate

    Row Counts by Table inserted in Qlik Replicate

    Is there someplace in QlikReplicate where I can see row counts inserted to a target table by some sort of timestamp?  In the UI, it keeps a running to... Show More

    Is there someplace in QlikReplicate where I can see row counts inserted to a target table by some sort of timestamp?  In the UI, it keeps a running total of rows applied to the target since the task was started.  But is there a way to find some sort of row count information for a table by a timestamp that could be used to reconcile back to the source?

    Show Less
  • forum

    Qlik Replicate

    Do replication tasks need to be stopped when switching Snowflake endpoint to Key...

    Hi I am in the process of updating our Snowflake endpoint in Qlik Replicate from password authentication to key pair authentication. The connection te... Show More

    Hi I am in the process of updating our Snowflake endpoint in Qlik Replicate from password authentication to key pair authentication.
    The connection test works fine with the new key pair setup, and tasks continue to run without interruption.

    The documentation explains how to configure key pair authentication but does not explicitly state whether it is best practice to stop active replication tasks during this change, or if it is safe to apply the change while tasks are running.

    Has anyone implemented this change without stopping tasks?

    Did you stop tasks before updating the pw to keypair method, or continue without stopping?

    Is there any risk of cached sessions or partial replication if tasks are not restarted?

    Looking for clarification on recommended best practice so we can document this properly for our environment, thanks.

    Show Less
  • forum

    App Development

    Issue creating rolling forecast table

    Hi,I am trying to create a table like below, where Actuals and Forecasts are shown in the same table. Users will be able to compare forecasts made in ... Show More

    Hi,

    I am trying to create a table like below, where Actuals and Forecasts are shown in the same table. Users will be able to compare forecasts made in different months with the Actual numbers and compare which of the multiple forecasts was more accurate.

    bsharma_velcro_0-1761651231119.png

    Appreciate any help with how to build the model to achieve this. I have attached sample data used in creating this table.

    Regards,

    BS

    Show Less
  • forum

    Qlik Replicate

    Time Change issue

    In Qlik Replicate the GUI has shown Qlik Replicate tasks Using an Oracle Source as about one hour behind, when the actual backlog is close to zero.  R... Show More

    In Qlik Replicate the GUI has shown Qlik Replicate tasks Using an Oracle Source as about one hour behind, when the actual backlog is close to zero.  Running repctl connect; gettaskstatus also shows a latency just over 3600 seconds.   This started when we changed from Daylight Savings to Standard Time Last weekend. 

    Our tasks using a MS SQL source show up to date. 

    Is this an issue with Qlik or on the Oracle side?  

    Show Less
  • forum

    Data Quality

    QS | Text value of dates is not getting link to dual field of date

    Hi,I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well... Show More

    Hi,

    I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well.

    Dual(Date1,-1*Date1)  giving result 2025/10

    While i tried to incorporate this changes into my existing dates i.e Date which is also holding dates in 2025/10 format but in Text format its not working.

    Let say i wanted to show YTD and Rolling 12 months data when clicking on action button.Its wokring fine and getting associated and selecting with green color.

    R12 Logic:

    =year(addmonths(TODAY(),-2))&'/'&if(num(month(addmonths(TODAY(),-2)))<10,'0','')&num(month(addmonths(TODAY(),-2)))&';' &year(addmonths(TODAY(),-3))&'/'&if(num(month(addmonths(TODAY(),-3)))<10,'0','')&num(month(addmonths(TODAY(),-3)))&';' &year(addmonths(TODAY(),-4))&'/'&if(num(month(addmonths(TODAY(),-4)))<10,'0','')&num(month(addmonths(TODAY(),-4)))&';' &year(addmonths(TODAY(),-5))&'/'&if(num(month(addmonths(TODAY(),-5)))<10,'0','')&num(month(addmonths(TODAY(),-5)))&';' &year(addmonths(TODAY(),-6))&'/'&if(num(month(addmonths(TODAY(),-6)))<10,'0','')&num(month(addmonths(TODAY(),-6)))&';' &year(addmonths(TODAY(),-7))&'/'&if(num(month(addmonths(TODAY(),-7)))<10,'0','')&num(month(addmonths(TODAY(),-7)))&';' &year(addmonths(TODAY(),-8))&'/'&if(num(month(addmonths(TODAY(),-8)))<10,'0','')&num(month(addmonths(TODAY(),-8)))&';' &year(addmonths(TODAY(),-9))&'/'&if(num(month(addmonths(TODAY(),-9)))<10,'0','')&num(month(addmonths(TODAY(),-9)))&';' &year(addmonths(TODAY(),-10))&'/'&if(num(month(addmonths(TODAY(),-10)))<10,'0','')&num(month(addmonths(TODAY(),-10)))&';' &year(addmonths(TODAY(),-11))&'/'&if(num(month(addmonths(TODAY(),-11)))<10,'0','')&num(month(addmonths(TODAY(),-11)))&';' &year(addmonths(TODAY(),-12))&'/'&if(num(month(addmonths(TODAY(),-12)))<10,'0','')&num(month(addmonths(TODAY(),-12)))&';' &year(addmonths(TODAY(),-13))&'/'&if(num(month(addmonths(TODAY(),-13)))<10,'0','')&num(month(addmonths(TODAY(),-13)))

    E.g 2025/10;2025/09;2025/08;...2024/11

    The problem statement is when clicking on R12 button my new Date1 which got created using Dual is not getting selected with green color although its getting associated as per Qlik associative nature.

    I tried many approache to get this link but no luck.

    Karim_Khan_0-1762429489716.png

    Karim_Khan_1-1762429517246.png

     

    Show Less
  • forum

    Qlik Automate

    Connection from Qlik Cloud to Org repository in Git Hub

    Good Morning,We are attempting to connect to a GitHub organization repository using the GitHub connector in Qlik SaaS to push published apps for versi... Show More

    Good Morning,

    We are attempting to connect to a GitHub organization repository using the GitHub connector in Qlik SaaS to push published apps for version management. We would appreciate your support in establishing this connection. Thank you.

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Task Fails – ODBC With CDC Source Connection Error

    We are facing an issue while running a Qlik Replicate task that replicates data from an ODBC source to a SQL Server destination. Both source and desti... Show More

    We are facing an issue while running a Qlik Replicate task that replicates data from an ODBC source to a SQL Server destination. Both source and destination connections have been created and tested successfully. However, when attempting to run the task, it fails with the following error:

    Source ODBC With CDC connection is setup with DNS.


    Error Details:
    Creating Metadata Manager's utility components failed
    Cannot create the source utility component
    Failed while preparing stream component 'Azure Sql Database ODBC Connect'.
    Cannot connect to ODBC provider
    RetCode: SQL_ERROR
    SqlState: 08S01
    NativeError: 10054
    Message: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

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

mvp-banner-side-image

Customer Story

Catalyst Cloud (Fusion)

Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.

Customer Story

Catalyst Cloud (Coeus SEP)

Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

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.

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

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.