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?

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 option “Download 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 :

Thank you in advance for any clarification or guidance!

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

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?

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.

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.

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.