Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 249,712 members
  • 5,967 online
  • 2,032,143 posts
  • 152,994 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    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 More

     

    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 do I paste the icons in Qlik code.

     

    Neha121_2-1745979129195.png

     

    Result:

    Neha121_3-1745979322593.png

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Replicate

    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 More

    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 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)

    NakulanR_0-1745974091966.png

    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?

    NakulanR_1-1745974178403.png

     

    Any insight into this is greatly appreciated.

     

    Thanks,

    Nak

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Talend Studio

    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 More

    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 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?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Connectivity & Data Prep

    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 More

    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, 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Talend Cloud

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    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 More

    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 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! 

    Sivalingam_1-1743519841978.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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])

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    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 More

    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 arrive horizontally. I can't find the reason or any help on how to configure it automatically horizontally.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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 window
    PDF Download
    Word Download
    Excel Download
    PowerPoint Download
    Document Download
     
    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly 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.

Location and Language Groups

Choose a Group

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

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!