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,512 members
  • 15,342 online
  • 2,036,180 posts
  • 155,188 Solutions
Announcements
Catch up on the newest Qlik features and improvements: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    QVF backup/restore with GitHub using native Qlik Cloud Automation blocks

    Hello Community,I’m backing up Qlik apps without data to GitHub and restoring them through Qlik Cloud Automation.The Base64 Legacy Block flow works fo... Show More

    Hello Community,

    I’m backing up Qlik apps without data to GitHub and restoring them through Qlik Cloud Automation.

    The Base64 Legacy Block flow works for small files (under 1 MB), but:

    • When used Native Export App Block returns a file object; and GitHub’s commit block requires Base64 Content.
    • Get Repository Content Github Block returns no inline content above 1 MB.
    • Call URL → native Import App, mapped body into File, it returns HTTP 200 but fails with error showing "file": null and missing file/file_resource.

    The same Call URL method performed through Postman, QVF downloaded and imports manually successfully.

    How can I pass a GitHub download into native Import App, and commit native Export App output without legacy Base64 blocks? 

    A working example would help.

    I have uploaded a Restore Qlik Cloud Automation for the reference. 

    Thanks

     

    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

    Management & Governance

    Qlik Sense patches regarding eMudhra CA issue (CVE-2026-111943, CVE-2026-91403, ...

    See e.g. https://www.heise.de/en/news/eMudhra-incident-compromises-eight-CA-certificates-11494689.htmlQlik Sense seems to use node.js and go. Thus, I ... Show More

    See e.g. https://www.heise.de/en/news/eMudhra-incident-compromises-eight-CA-certificates-11494689.html

    Qlik Sense seems to use node.js and go. Thus, I expect qlik needs to be patched, right?

    Please let us know which patches are necessary and their ETA if not yet released.

    Show Less
  • forum

    Qlik Replicate

    Failing to replicate a table from cloud MariaDB to on prem MS SQL

    Hi all,we are experiencing an issue with a Qlik Replicate Full Load from MariaDB to SQL Server.The source table is very large, containing approximatel... Show More

    Hi all,

    we are experiencing an issue with a Qlik Replicate Full Load from MariaDB to SQL Server.

    The source table is very large, containing approximately 7.6 billion rows.

    The load fails while Replicate tries to create the primary key/unique index on the target table:

    Stream component 'st_1_TargetEndpoint' terminated
    Stream component failed at subtask 1, component st_1_TargetEndpoint
    
    Error executing data handler
    Endpoint is disconnected
    
    Execute create Primary Key/Unique Index failed, statement:
    
    CREATE UNIQUE INDEX [LARGE_DATA_TABLE_PK]
    ON [TARGET_SCHEMA].[LARGE_DATA_TABLE]
    (
        [KEY_COLUMN_1],
        [TIMESTAMP_COLUMN],
        [SEQUENCE_COLUMN]
    )
    
    RetCode: SQL_ERROR
    SqlState: HYT00
    NativeError: 0
    Message: [Microsoft][ODBC Driver 18 for SQL Server]
    Query timeout expired
    
    Failed (retcode -1) to execute statement:
    CREATE UNIQUE INDEX [LARGE_DATA_TABLE_PK]
    ON [TARGET_SCHEMA].[LARGE_DATA_TABLE]
    (
        [KEY_COLUMN_1],
        [TIMESTAMP_COLUMN],
        [SEQUENCE_COLUMN]
    )

    The Full Load is segmented using KEY_CULUMN_1. We also checked the source-side performance and investigated the SQL Server load and connection behavior.

    The actual failure seems to occur when Replicate creates the unique index after loading the table.

    We are currently looking into the timeout settings in Replicate/ODBC.

    Has anyone experienced this behavior with very large tables before?

    In particular:

    • Is there a Replicate task or internal parameter that controls the timeout for index/PK creation?
    • Are there recommended settings for tables of this size?
    • Is there a recommended way to prevent Replicate from treating a long-running CREATE UNIQUE INDEX as a disconnected endpoint?
    • Are there recommended settings for the destination MS SQL Server?

    Any hints or recommended settings would be appreciated.

    Thanks in advance!

    Show Less
  • 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

    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
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image