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,053 members
  • 8,676 online
  • 2,051,977 posts
  • 155,107 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • forum

    Visualization and Usability

    "Corrupted Data" - QVF - Qliksense Desktop Nov 2019

    Hi All,  So.. I have an app that got "Corrupted Data" when trying to open it.. Can't access the app at all. I think the corrupted data happened due to... Show More

    Hi All, 

     

    So.. I have an app that got "Corrupted Data" when trying to open it.. Can't access the app at all. 

    I think the corrupted data happened due to the fact i shutdown the app/Qliksense while it was saving the app (I had hit the save button and exited before done)


    I am using desktop version and tried below actions: 

    1. Create a settings.ini file with:

    [Settings 7]
    AppRecoveryMode = 1

    Could not find an already existing settings.ini so created it from notepad and added it to sense folder (did not find any engine folder?) should it be there? 

    However, No effect. 

    2. Duplicate the corrupted qvf and trying to open the duplicate.. still corrupted. 

    3. Trying to open the app "Without data" - Did not work.. still corrupted. 

    4. Some one wrote this in a similar topic: 

    ""I just had the same "corrupt data" problem and could not recover it by duplicating the file. Attempting to load the app without data did not work either.

    However - I was happy to find the entire data load script in the most recent log file, which I found in the \Qlik\Sense\Log folder. I was able to easily remove all the time-stamps with a good text editor (like Notepad++). All that was left was replacing the variable values with variable names and adding back the ";" at the end of each statement.

    Not the full restore that I needed, but better than rebuilding from scratch.""

    However, I could not find this log ? it was days ago this corrupted thing happened and I guess I am not skilled enough to pinpoint that log and modify it correctly...

     

    What is my options ? slim to none ? 

    Show Less
  • forum

    Qlik Automate

    Can an automation use a OAuth M2M user?

    Hi,We have, to enable higher-powers within Qlik CLI, created a OAuth M2M client which in turn automatically created a Qlik User with the OAuth's name.... Show More

    Hi,

    We have, to enable higher-powers within Qlik CLI, created a OAuth M2M client which in turn automatically created a Qlik User with the OAuth's name.

    Now, that user when used as the 'Context' in Qlik CLI works perfectly even for bulk changes, but we're now starting to consider "bigger" bulk changes so, does anyone know if it is possible (and if so, how) to use that user i.e. authenticate as the OAuth user in an Automation to make bulk changes like for example move private apps, sheets, etc from one (disabled) user to another?

    Thank you.

    Show Less
  • forum

    Qlik Answers

    TELEGRAM: DRMIKE100 TO BUY ADDY 10MG IN USA WITHOUT SCRIPT

    TELEGRAM: DRMIKE100 TO BUY ADHD MEDS  30MG IN USA WITHOUT SCRIPT
  • forum

    Scalability

    Established a connection but unable to execute in Qlik Sense Scalability tool

    Hi Guys, I am new to the scalability tool but I am trying to establish a connection from the Qlik Sense Enterprise Scalability tool using a virtual pr... Show More

    Hi Guys,

    I am new to the scalability tool but I am trying to establish a connection from the Qlik Sense Enterprise Scalability tool using a virtual proxy with header authentication. Please find the issue below:

    Using the user manual:

    • I created a virtual proxy as required
    • Created a UDC to import test users
    • Assigned licenses to the test users
    • Added the hostname, Virtual proxy prefix, Header Name etc. to the connection tab
    • Set up few scenarios and Users
    • Was able to get a 'Connection successful' message in the connection tab but unable to connect and load app Structure
    • Saved the script into JSON format
    • Loaded and started the execution of JSON script into the executor

    Issue:

    • While executing, I am getting an error:
      • 1 error occurred:
        Unexpected status code: 500 Internal Server Error (get https://<HostName>/<Virtual Proxy prefix>/api/hub/v1/apps/favorites): unexpected response status code<500> expected<[200]>
    • The same error pops us even while trying to connect and populate App Structure

    Troubleshooting:

    My Findings:

    • Removing the 'api' (i.e., https://<HostName>/<Virtual Proxy prefix>/hub/v1/apps/favorites ) from the URL helped me access the link and even look at the apps I published/want to simulate in Qlik Sense Enterprise

    I'm not sure if the 'api' in the link is causing this issue, if yes, could you let me know how to remove the api from the URL or if there is something else that I'm missing. It would be great if you guys could help me out.

    Would really appreciate if you guys looked into it as well @Daniel_Larsson @Jens_Argentzell @Sebastian_Fredenberg @vinieme12 @Andre_Sostizzo 

    Thanks in advance

    Show Less
  • forum

    Healthcare

    TELEGRAM: DRMIKE100 TO BUY ADHD MEDS 20MG IN USA WITHOUT SCRIPT

    TELEGRAM: DRMIKE100 TO BUY ADHD MEDS  20MG IN USA WITHOUT SCRIPT. 
  • 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
  • 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
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image