Recent Discussions
-
Add icon in Script for inline table
I have a piece of code which has these icons in inline table. not sure how this is done. I want to create another table with different icons but how ... Show MoreI have a piece of code which has these icons in inline table. not sure how this is done. I want to create another table with different icons but how do I paste the icons in Qlik code.
Result:
-
Licensing implications of the new unified Snowflake target endpoint
Hi Support, In the What's New section of the user guide for the upcoming May 2025 release of Replicate (here), there's a part which talks about unifyi... Show MoreHi Support,
In the What's New section of the user guide for the upcoming May 2025 release of Replicate (here), there's a part which talks about unifying the Snowflake target endpoints into a single endpoint rather than having a separate one for each cloud provider.
The note says that by the November 2025 release, all the standalone endpoints will be merged into the single unified endpoint using the existing license. (see below)
What does that mean from a licensing standpoint? Considering current replicate licenses list the Snowflake targets with the cloud providers (example below). Does this mean that customers using Snowflake as a target will need a new license where the target_type would be 'Snowflake'? Or would they be able to continue with the license they have, and Replicate will detect that 'SnowflakeAWS', for example, is a valid target_type to have in the license?
Any insight into this is greatly appreciated.
Thanks,
Nak
-
Can you do a PATCH request using tRest component?
An API we are hoping to interface with using Talend Data Integration (and Talend Studio) requires us to use the HTTP Method PATCH. However, it appears... Show MoreAn API we are hoping to interface with using Talend Data Integration (and Talend Studio) requires us to use the HTTP Method PATCH. However, it appears that the `tRest` compoent only supports GET, POST, PUT and DELETE.
Is there a way to add PATCH to the possible methods to `tRest` or is there another component I should use to call this API?
-
Trying to connect Qlik and Azure Storage
Hello,I am trying to connect Qlik and load data from Azure storage. I've tried all the possible links present in the container on the Azure Storage, b... Show MoreHello,
I am trying to connect Qlik and load data from Azure storage. I've tried all the possible links present in the container on the Azure Storage, but what I got as a response when trying to connect (after authenticating) is: "An error occurred: The remote server returned an error: (400) Bad Request."Do you know how to solve it, or do you have a (step-by-step) configuration I should follow?
Thank you
-
Ingesting parquet files using Qlik Talend Cloud
Hi,I wasn't sure where exactly to post this as I couldn't see a Qlik Talend Cloud forum. I was wondering, is it possible using Qlik Cloud or Talend Cl... Show MoreHi,
I wasn't sure where exactly to post this as I couldn't see a Qlik Talend Cloud forum. I was wondering, is it possible using Qlik Cloud or Talend Cloud capabilities to ingest parquet? I'm aware that Talend Studio jobs can ingest parquet but is it possible purely within Qlik Cloud or Talend Cloud only? ie, a pipeline?
Help with this is appreciated. Thank you.
Regards,
Mohammed
-
Run the script only on a Monday and retains the value for other days.
Hello qlikers I have written a script. But a small area of the script should be run on a Monday only and the generated value needs to be retained for... Show MoreHello qlikers
I have written a script. But a small area of the script should be run on a Monday only and the generated value needs to be retained for other days.
So, for example, today is Monday and the script should run the complete script. When we have Friday, the script should use the Monday generated value on behalf of "Monday script".
How can I do that?
Thank you in advance!
-
Insight Advisor - what causes disabled fields?
Hi, I have a couple of questions regarding Insight Advisor. 1) In my app's Logical Model, I have a Measure group with two particular fields in it.Both... Show MoreHi, I have a couple of questions regarding Insight Advisor.
1) In my app's Logical Model, I have a Measure group with two particular fields in it.
Both fields are configured with the same characteristics: Visibility = visible, Classification = measure, Data Value Lookup = no, Default Aggr = sum. Both fields are populated with integer values.
When I go to the Insight Advisor page I can see both fields displayed in the Fields list on the left.
But when I choose the Calculated measure (KPI) analysis type, one of the fields becomes disabled so that it's not selectable. But the other remains enabled and is selectable.
What would cause this difference in behavior?
2) Also, is there any issue caused by putting fields that are classified as measures into a Dimension group or fields that are classified as dimensions into a Measure group? Since you are allowed to do this, and Qlik actually does it by default sometimes, I would think this does not cause a problem. But if it doesn't matter where you put fields, then why have separate Dimension and Measure group types? Is it simply for organizational purposes?
Thank you for any responses,
Steven
-
Result of Expression Not Summing Correctly
I am trying to build an expression that determines the number of elapsed business days in the month. The Calendar.BusinessDayFlg field is either 1 or ... Show MoreI am trying to build an expression that determines the number of elapsed business days in the month. The Calendar.BusinessDayFlg field is either 1 or 0 for business day Y/N. The vMonthNumber is a variable to tie to current month on a fiscal year basis. The expression below gives me the OK message, yet the result of the expression is 0, which is not accurate. Running this on April 29, it should give me a result of 20 (excluding weekends, no holidays in April). Attached is an output of dimensions to show how the data is setup.
Sum({$<YearDimension={'CurrentYear'},FiscalMonthNBR={$(vMonthNumber)},EncounterDate={'<$(=DATE(Today(),'YYYY-MM-DD'))'}>}[Calendar.businessdayflg])
-
PDF arrives vertically
Hello, good afternoon. I'm having a problem when I try to subscribe via email. The specific problem is that the PDF arrives vertically and should arri... Show MoreHello, good afternoon. I'm having a problem when I try to subscribe via email. The specific problem is that the PDF arrives vertically and should arrive horizontally. I can't find the reason or any help on how to configure it automatically horizontally.
-
Table Dimensions show top 10 only.
Hi,I have a table with four dimensions, and I want to display only the Top 10 rows based on the largest values in one of those dimensions (let's call ... Show MoreHi,
I have a table with four dimensions, and I want to display only the Top 10 rows based on the largest values in one of those dimensions (let's call it Column X).
My goal is to:
Sort the table by Column X (descending)
Show only the top 10 values by Column X
Keep the table dimensions-only (no visible measures)
However, I’m running into a few issues:
The "Limitation" option is disabled when using only dimensions.
If I use Column X as a measure, it requires me to choose a dimension to group by, which doesn't give the correct granularity for my use case.
The only workaround I've found is to use Column X as both a dimension and a measure, then apply a limitation — but this displays Column X twice, and there’s no clean way to hide the extra column, which feels like a clumsy solution.
To complicate things further, I plan to apply this approach in another table where I’ll also need to filter one of the dimensions beforehand, so I want a reusable and clean method.
Is there a way to filter a table to the top N rows based on a dimension’s numeric value, without displaying the ranking field or duplicating columns?
Thanks!
Opens in new windowPDF DownloadWord DownloadExcel DownloadPowerPoint DownloadDocument Download