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: 
  • 283,499 members
  • 14,726 online
  • 2,036,175 posts
  • 155,188 Solutions
Announcements
Catch up on the newest Qlik features and improvements: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Retrieve QVD file ID

    Good Morning all,this one might be better suited in the API section, but i dont know....I am trying to get the IDs of all QVDs in a given (subfolder) ... Show More

    Good Morning all,

    this one might be better suited in the API section, but i dont know....I am trying to get the IDs of all QVDs in a given (subfolder) of a space from within my LOAD script. I tried setting up a REST connection (worked) and also giot to see a few QVDs, but these seemed to be only QVDs from my personal folder...Can anyone help 

    If this will not work: My ultimate goal is to delete QVDs (using an automation) in a given space based on a list of QVD names that need to be deleted. (I tried that as well, but failed as i need the file IDs for the files i want to delete...which i dont know how to get)

    Thanks for any kind of support!

    Show Less
  • forum

    App Development

    How can I display values ​​for specific months in my report using a ValueList?

    Good afternoon, community.I am creating a report in which I am using a `ValueList` within my dimension—for example: `ValueList('RESULTADO 2026', 'VS 2... Show More

    Good afternoon, community.

    I am creating a report in which I am using a `ValueList` within my dimension—for example: `ValueList('RESULTADO 2026', 'VS 2025', 'VS KPI 2026')

    And in my measure, I include this formula:

    =If(
    ValueList(
    'RESULTADO 2026',
    'VS 2025',
    'VS KPI 2026'
    ) = 'RESULTADO 2026',

    Num(Sum({<Mes=,Año = {'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas),'#,##0'),

    If(
    ValueList(
    'RESULTADO 2026',
    'VS 2025',
    'VS KPI 2026'
    ) = 'VS 2025',

    Num((Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas) - Sum({<Mes=,Año={'$(vAñoAnterior)'},fecha = {"<=$(vMaxFechaAnterior)"}>} Numero_Entradas))
    /Sum({<Mes=,Año={'$(vAñoAnterior)'},fecha = {"<=$(vMaxFechaAnterior)"}>} Numero_Entradas),'0.0%'),

    Num((Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas)/Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>}Total_Presupuesto)),'0%')
    )
    )

    If I don’t select a specific month, my results appear correctly in the report. However, if I select a month—for example, September—the data for September is displayed correctly, but the data for the preceding months is shown as percentages instead of the correct values.
    The measure I am using represents a cumulative total from January to September.
    How can I ensure that, when I select a specific month, the data for the unselected months is also displayed correctly?

    I have attached images showing how my report looks.

    I look forward to your suggestions.
    Thanks.

     

    Show Less
  • forum

    Qlik Replicate

    In Qlik replicate Nov 2025 version Rename change table is not working as it was ...

    Rename Change Table | Qlik Replicate HelpInformation noteGlobally renaming a Change Table will override the Change Table suffix defined in the task se... Show More

    Rename Change Table | Qlik Replicate Help
    Information note
    Globally renaming a Change Table will override the Change Table suffix defined in the task settings.
    The Change Table name must be different from the source table names. Otherwise, a table error will occur.

    Issue with Using a PostgreSQL-Based database as a target

    Postgresql 17 driver as per documentation is used. https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/PostgreSQL/postgresql.htm#ar_postgresds_802412600_1325150

     

    In Qlik Replicate 2024:

    =======================

    Once the Global variable is defined for renaming "change table". that is the only rule which is applied.

    The suffix "__ct" in the Change Table Settings under TASK Setting == > Change processing is ignored.

    Table name : ACTY

    EX: Global rule for rename change table : 

    Rename Change Table 
    for ABC.%
    to 'cdc_'||lower($AR_M_SOURCE_TABLE_NAME)||'_2026'
     
    Final change table name : cdc_acty_2026
     
    The "__ct" suffix in the change processing under task setting is ignored.
     

    In Qlik Replicate 2025:

    =====================

    Once the Global variable is defined for renaming "change table". that is the only rule which is applied.

    The suffix "__ct" in the Change Table Settings under TASK Setting == > Change processing is added after the global variable is applied.

    Table name : ACTY

    EX: Global rule for rename change table : 

    Rename Change Table 
    for ABC.%
    to 'cdc_'||lower($AR_M_SOURCE_TABLE_NAME)||'_2026'
     
    Final change table name : cdc_acty_2026__ct
     
    The "__ct" suffix in the change processing under task setting is ignored.
    Show Less
  • forum

    Catalog and Lineage

    Is there a way to link to the Lineage Page for an App in Qlik Cloud?

    I am trying to build a URL so i can link from a Cataloging app that we are building directly to an Apps lineage sheet.  A sample image of what i am tr... Show More

    I am trying to build a URL so i can link from a Cataloging app that we are building directly to an Apps lineage sheet.  A sample image of what i am trying to link to is attached. But so far i have been unsucessful in building a working URL.  For example, when i click on Tools-->Lineage the URL looks like this: 

    https://mytenant.us.qlikcloud.com/lineage/qri%3Aapp%3Asense%3A%2F%2F876c4y32-3rj4-5t73-sr65-98k40d63j234?resourceName=My%20App%20Name 

    But i don't know what this number is in the middle. The one that starts with 876c4... It's not the app id and it's not a number i can find in any of the App, Lineage or Item API's or from App/Item information in an Automation. Without it, it doesn't appear i can open that sheet.

    Has anyone linked to this before?  is it even possible?

    Thanks

    Show Less
  • forum

    Qlik Replicate

    High latency alerts after switching back to Standard Time on Nov. 1st

    Anyone experiencing high latency after the switch to Standard Time last weekend?   Any suggestions on how to resolve?  We just upgraded to Replicate v... Show More

    Anyone experiencing high latency after the switch to Standard Time last weekend?   Any suggestions on how to resolve?  We just upgraded to Replicate version May 2026 a couple of weeks ago.  Thank you!

    Show Less
  • forum

    App Development

    charts for analyzing flow

    Flow data usually arrives as a table of from-to pairs, and the same table can become a Sankey, a dependency wheel, or an arc diagram. Which one to sta... Show More

    charts-for-flow-and-process-analysis

    Flow data usually arrives as a table of from-to pairs, and the same table can become a Sankey, a dependency wheel, or an arc diagram. Which one to start with comes down to two questions: does the position of the nodes matter, and do you need to see how much moves or what connects to what?

    Our new guide goes through five charts for flow data: Sankey diagram, flow map, arc diagram, dependency wheel, and network graph. For every chart there is the job it does best and the way it misleads, plus a worked example that runs one set of team handoffs through three of them.

    👉 Flow & Process Charts: How Much Moves, What Connects

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Explorer for Developers – "No progress data available" despite successful G...

    Hi @Øystein_Kolsrud ,I'm trying to use Qlik Explorer for Developers to analyze application opening performance (Cold and Warm Open) in Qlik Sense Ente... Show More

    Hi @Øystein_Kolsrud ,

    I'm trying to use Qlik Explorer for Developers to analyze application opening performance (Cold and Warm Open) in Qlik Sense Enterprise on Windows.

    However, the Progress Report always shows "No progress data available", even though the application opens successfully.

     

    Environment:

    • Qlik Explorer for Developers: 2.11.1

    • Qlik Sense Enterprise on Windows November 2025 p15 and May 2026 P7

    • Tested both through an Nginx reverse proxy and with a direct connection to Qlik Sense

    • info template selected

    I enabled WebSocket traffic logging and found something interesting.

    The OpenDoc operation completes successfully, and the Engine returns detailed progress information through GetProgress.

    For example, during a Cold Open test:

    • Loading from storage

    • Loading fields

    • Loading tables

    • Attached to loaded document

    • Open document end, time 1794.8ms

    In this test, 34 progress messages were successfully received across multiple GetProgress calls, including the final response with qFinished: true.

    However, none of this information appears in the Progress Report section of Qlik Explorer.

    The same behavior occurs during Warm Open, and I reproduced it both with and without the external reverse proxy.

    This suggests that the Engine provides the required information, but Qlik Explorer may not be displaying or processing it correctly.

    Is this a known issue or am I missing some configuration?

    I can share sanitized WebSocket traffic logs if needed.

    Thanks!

     

    Show Less
  • forum

    Talend Studio

    Excel components issues after upgrading JRE (amazon-corretto 8.512.09.1)

    Hi,I'm using TOS V7.3.1After upgrading JRE from amazon-corretto 8.462.08.1 to amazon-corretto 8.512.09.1 on execution server, the excel components tFi... Show More

    Hi,

    I'm using TOS V7.3.1

    After upgrading JRE from amazon-corretto 8.462.08.1 to amazon-corretto 8.512.09.1 on execution server, the excel components tFileOuputExcel and TFileInputExcel doesn't work anymore.

    Below the message : 

    Exception in thread "main" java.lang.UnsatisfiedLinkError: no freetype in java.library.path
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)
    at java.lang.Runtime.loadLibrary0(Runtime.java:843)
    at java.lang.System.loadLibrary(System.java:1136)
    at sun.font.FontManagerNativeLibrary$1.run(FontManagerNativeLibrary.java:59)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.font.FontManagerNativeLibrary.<clinit>(FontManagerNativeLibrary.java:32)
    at sun.font.SunFontManager$1.run(SunFontManager.java:346)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.font.SunFontManager.<clinit>(SunFontManager.java:342)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:348)
    at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:82)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
    at java.awt.Font.getFont2D(Font.java:491)
    at java.awt.Font.canDisplayUpTo(Font.java:2056)
    at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
    at java.awt.font.TextLayout.<init>(TextLayout.java:531)
    at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:273)
    at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)
    at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:82)
    at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:674)
    at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:695)
    at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:87)
    at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:130)
    at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tDBInput_1Process(Bnppf_Abba_T9_T10_Reports.java:4767)
    at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tWarn_2Process(Bnppf_Abba_T9_T10_Reports.java:4330)
    at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tWarn_1Process(Bnppf_Abba_T9_T10_Reports.java:4118)
    at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.runJobInTOS(Bnppf_Abba_T9_T10_Reports.java:8828)
    at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.main(Bnppf_Abba_T9_T10_Reports.java:8617)

    But it works when I launch the jobs from Open Studio in my laptop.

    Any suggestion please ?

     

    Many thanks

     

    Show Less
  • forum

    Data Movement & Streaming

    How to configure Progress OpenEdge data source with Qlik Cloud and QDG

    Hello, Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway? I am getting error "Status(StatusCode="Internal", Detail="C... Show More

    Hello,

    Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway?

    I am getting error "Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values ​​for Username‚ Password‚ Host and other properties. Description: Invalid connection string attribute - ERROR [08001] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server. Verify Host Name and Port Number.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: gatewayInstance."

     

    What was done:
    - Installed the Progress 12.2 ODBC Driver driver, configured it and the connection test was successful;
    - During the connection, an attempt was made to fill in the Connection String field as shown in the example image available at https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/sample-connection-strings.htm;
    - QDG is working correctly with Microsoft SQL Server.

    Could you help us with how to fill in these attributes?


    Best Regards,
    Madson

     

     

     

     
    Show Less
  • forum

    Administering and Monitoring

    Qlik Talend Cloud monthly release

    Qlik Talend Cloud is being updated, The first region is being deployed, it will take a few days for all regions to be updated.Please refer to the late... Show More

    Qlik Talend Cloud is being updated,

    The first region is being deployed, it will take a few days for all regions to be updated.
    Please refer to the latest Release notes to see what's new.

    https://help.qlik.com/talend/en-US/release-notes/8.0/r2025

     

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image