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: 
  • 279,038 members
  • 16,024 online
  • 2,051,971 posts
  • 155,106 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Answers

    Import a QVF into an app in another Tenant

    I have downloaded a QVF from my App and would like to open that QVF in another tenant to see all the data and vizualizations. I would like to know how... Show More

    I have downloaded a QVF from my App and would like to open that QVF in another tenant to see all the data and vizualizations. I would like to know how I can do this?

    Show Less
  • forum

    Administering and Monitoring

    Can't Access Exam and a Bug

    First this should be on Discover Learning, but there's no way to select that for help. That's not what this ticket is for though, that's just a bonus.... Show More

    First this should be on Discover Learning, but there's no way to select that for help. That's not what this ticket is for though, that's just a bonus.

    I am logged into my US Navy Flankspeed email account and am getting the error "This activity cannot be accessed from your account." when attempting to access 'Qlik Sense Qualification Exam – Business Analyst 2025' which is linked from the 'Qlik Sense Qualification Exam – Business Analyst 2024' under the NAVSEA trainings.

    Show Less
  • forum

    QlikView

    QlikView Desktop September 2025 IR/SR1/SR2 – Severe Performance/Responsiveness I...

    Hi,We have QlikView Server and QlikView Desktop installed on a Windows Server 2022 machine, which we access via Remote Desktop.Earlier this year, I up... Show More

    Hi,

    We have QlikView Server and QlikView Desktop installed on a Windows Server 2022 machine, which we access via Remote Desktop.

    Earlier this year, I upgraded our QlikView installation from May 2023 to September 2025 SR1. After the upgrade, I noticed that QlikView Desktop had become extremely slow and unresponsive.

    When QlikView Desktop is started, the menus and the application itself initially seem to work normally. However, as soon as I open a QlikView document, the application becomes very sluggish. On AccessPoint everything works fine.

    For example:

    - Clicking the QlikView > About menu can take 2–4 seconds before anything happens.
    - Right-clicking an object on a report can take several seconds before the context menu appears.
    - Scrolling in list boxes is very jerky and noticeably delayed.
    - In general, there is a significant delay between clicking something and QlikView responding.

    At the time, I did not have time to investigate the issue further.

    Today I uninstalled QlikView Desktop and installed the May 2023 version again. The performance immediately returned to normal. When clicking objects or menus in a QlikView document, everything responds almost instantly.

    I then upgraded QlikView Desktop to May 2024 SR1, and the performance was still normal.

    After that, I upgraded to September 2025 IR, and the performance problem immediately returned.

    So far, my testing looks like this:

    - May 2023: Good performance
    - May 2024 SR1: Good performance
    - September 2025 IR: Very slow / significant UI delays
    - September 2025 SR1: Very slow / significant UI delays
    - September 2025 SR2: Very slow / significant UI delays

    I have also disabled the antivirus temporarily, but this did not make any difference.

    Has anyone else experienced similar QlikView Desktop performance or UI responsiveness issues with the September 2025 releases?

    Show Less
  • forum

    App Development

    Incorrect time (hh:mm) format when export the data into excel sheet

    Hi All, When exporting data that includes a time column formatted as 'hh:mm' into an Excel sheet, I encounter an issue where the format is not preserv... Show More

    Hi All,

    When exporting data that includes a time column formatted as 'hh:mm' into an Excel sheet, I encounter an issue where the format is not preserved correctly. 

    Requirement- 

    • Time Format Preservation: The exported data should maintain the 'hh:mm' format as shown in the QlikSense report.

    ChaithraMahesh_1-1725517860363.png

    • Table Header: The exported table should include "Total" at the top.
    • Color Formatting: The color formatting in the "Flag" column should also be preserved.

    Here's the situation and what I've tried so far:

    Expression: Total Hours = interval(sum(Hours),'hh:mm')

    1. Export with Table Formatting Enabled:

    When exporting data with "Table Formatting" enabled, the time column "Total Hours" displays in a 24-hour format instead of the intended 'hh:mm' format.

    For instance, a total of "45:21" hours appears as "21:21" after subtracting 24:00 hours

    [ (45:21) - (24:00) = (21:21)]

    ChaithraMahesh_2-1725517988334.png

    2. Export without Table Formatting:

    Exporting without enabling "Table Formatting" preserves the time format as 'hh:mm'. However, this method causes other issues, such as the loss of color formatting in another column called "Flag."

    ChaithraMahesh_3-1725518976916.png

    I attempted using the "Text" function instead of just the "Interval" function to achieve the desired export format. Here’s what I did and the issue that arose:

    Attempted Solution

    • Expression Used: Total Hours = Text(interval(sum(Hours),'hh:mm'))
    • Result: This approach allowed me to export the data with "Table Formatting" enabled, preserving the 'hh:mm' format as required.

    Issue Encountered

    • Calculation Problem: When this format is used, the total hours displayed at the bottom of the Excel sheet only show the count of records, not the sum of the selected records. For example, if the user selects records 4th and 5th row in excel, the bottom of the sheet displays a count (highlighted in yellow) rather than the sum. Additionally, the top of the page shows the format as "General," making it difficult for users to calculate the total hours for selected records.
    • User Frustration: Business users have to manually convert these text values into hours, which involves complex calculations and is frustrating for them.

    Requirement

    • The export should display the total hours in 'hh:mm' format while allowing users to easily calculate totals for selected records. Ideally, users should be able to see the sum of selected rows in the Excel sheet without additional complex steps.

    ChaithraMahesh_4-1725520726969.png

    Hence, I need a solution to export the data so that the "Total Hours" column maintains the 'hh:mm' format, while also retaining color formatting in the "Flag" column if "Table Formatting" in either ways enabled or not enabled and also enable business see the custom "Sum" of the records.

    Show Less
  • forum

    Connectivity & Data Prep

    SAP Connector 8.3 - Which transports need to be installed?

    Hi, we would like to use SAP Connector 8.3. However, I’m not sure which transports need to be installed. According to Qlik Help, they are H6AK900159 a... Show More

    Hi, we would like to use SAP Connector 8.3. However, I’m not sure which transports need to be installed. According to Qlik Help, they are H6AK900159 and E66K900154. But these aren’t included in the current ZIP file. The help page also says “version 8.1” above the table. Is the information there out of date? I’d appreciate any help.

    Qlik_97_0-1788256616529.png

    Qlik_97_1-1788256645508.png

     

     

    Show Less
  • Talend Data Catalog

    How upgrade Harvesting Server in datacatalog

    Hi,I have datacatalog.us.cloud.talend.com/MM in cloud with a Harvesting Server in a windows server with  version 20250224 but I want to upgrade the ha... Show More

    Hi,

    I have datacatalog.us.cloud.talend.com/MM in cloud with a Harvesting Server in a windows server with  version 20250224 but I want to upgrade the harvesting to version 20250829.

    What steps or guide use to do this. 

     

    Thanks

    Show Less
  • forum

    Connectivity & Data Prep

    QlikView S4/HANA 2025 with Qlik SAp Connector

    Hello everyone,is it possible to use the QlikSAPConnector to extract data from an SAP S4/HANA 2025-System with SAP Basis 816, as in the documentation ... Show More

    Hello everyone,

    is it possible to use the QlikSAPConnector to extract data from an SAP S4/HANA 2025-System with SAP Basis 816, as in the documentation it's only specified for S4/HANA 2022. 

    I'd appreciate any help!

    Show Less
  • forum

    Integration, Extension & APIs

    Activating On-Demand Reports via API

    Hi everyone,I'm trying to identify and test all the API endpoints required to clone an app that has a Tabular Excel report associated with it.So far, ... Show More

    Hi everyone,

    I'm trying to identify and test all the API endpoints required to clone an app that has a Tabular Excel report associated with it.

    So far, I've managed to successfully clone the app and re-associate the report template, as the template association is lost during the app cloning process.

    The last step I'm missing is enabling the On-Demand functionality, which can be done from the UI through the following step:

    cristian_dalsanto_0-1788254064690.png

     

    Does anyone know if it's possible to perform this operation via API? If so, which endpoint should be used?

    Thanks in advance!

    Cristian

    Show Less
  • forum

    App Development

    Obtain Total for the Following Year

    Hello !!!!I have a requirement that I hope you can help me with. What I want to achieve is to carry over the final total from 2025 in an Income and Ex... Show More

    Hello !!!!

    I have a requirement that I hope you can help me with. 

    What I want to achieve is to carry over the final total from 2025 in an Income and Expenses table, so that this total is reflected in the STA line when selecting 2026.

    Ideally, this should work automatically for future years as well. For example, when 2027 becomes the new year, the final total from 2026 should automatically be carried over to the STA line for 2027.

    What I have achieved so far is to carry over the 2025 final total to the STA line. However, when I move to 2026, the value changes, whereas I need the value to remain fixed based on the previous year's final total.

    I have attached my current formula, which achieves the first part of the requirement, along with the variables and an Excel file for better understanding of the expected behavior.

     

    If(
    af_estado_cuenta_item = 'Egresos'
    and af_estado_cuenta_concepto = 'Saldo temporada anterior',

    Sum(Total
    Aggr(
    (
    If(
    af_estado_cuenta_item = 'Ingresos'
    and af_estado_cuenta_descripcion_estado_ingresos <> 'R',

    Pick(
    Match(
    af_estado_cuenta_concepto,
    'Ingreso Cerezas',
    'Ingreso Ciruelas',
    'Ingreso Kiwis',
    'Ingreso Manzanas'
    ),

    Sum(
    {<
    af_especie={'Cerezas'},
    af_estado_cuenta_concepto={'Ingreso Cerezas'}
    >}
    Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
    ),

    Sum(
    {<
    af_especie={'Ciruelas'},
    af_estado_cuenta_concepto={'Ingreso Ciruelas'}
    >}
    Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
    ),

    Sum(
    {<
    af_especie={'Kiwis'},
    af_estado_cuenta_concepto={'Ingreso Kiwis'}
    >}
    Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
    ),

    Sum({<af_temporada={2025}>}
    {<
    af_especie={'Manzanas'},
    af_estado_cuenta_concepto={'Ingreso Manzanas'}
    >}
    Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
    )
    ),

    If(
    GetFieldSelections(rnp_tipo) = 'RNP Ppto',
    Sum(af_estado_cuenta_rnp_ppto_monto),

    If(
    GetFieldSelections(rnp_tipo) = 'RNP Real Acum Ppto',
    Sum(af_estado_cuenta_rnp_rap_monto),

    If(
    GetFieldSelections(rnp_tipo) = 'RNP Prom',
    Sum(af_estado_cuenta_valor_total_ingreso_real)
    )
    )
    )
    )
    ),
    af_estado_cuenta_item,
    af_estado_cuenta_concepto
    )
    ),
    )

    Variables:
    $(v_cajasdn) = sum(if(af_estado_analisis_financiero_produccion = 'P',af_cajas_vigente_real,af_cajas_produccion_real))
    $(v_rnp_Ingresos_I) = Avg(resultado_neto_productor_unitario_caja_NRNP)

    Thank you!

    Show Less
  • forum

    Qlik Replicate

    Unable to replicate from on premise SQL server into Azure SQL Server due to encr...

    We are running ODBC 18 drivers for SQL Server.The source endpoint is on premise SQL Server 2022 but running on compatibility mode 110. We can't change... Show More

    We are running ODBC 18 drivers for SQL Server.

    The source endpoint is on premise SQL Server 2022 but running on compatibility mode 110. We can't change it yet.

    The target endpoint is Azure SQL Server.

    Failed to check if table dbo.AIFENDPOINTACTIONPOLICY has encrypted columns
    mssql_ae_is_table_encrypted(...) failed in CREATE STATEMENT for '
    select count(*)
    from sys.columns c
    inner join sys.column_encryption_keys k on c.column_encryption_key_id = k.column_encryption_key_id
    inner join sys.tables t on c.object_id = t.object_id
    where c.encryption_type IS NOT NULL and schema_name(t.schema_id) = N'dbo' and t.[name] = N'AIFENDPOINTACTIONPOLICY'
    '
    RetCode: SQL_ERROR SqlState: 42S02 NativeError: 208 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'sys.column_encryption_keys'. Line: 1 Column: -1

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image