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,297 members
  • 6,014 online
  • 2,036,118 posts
  • 155,186 Solutions
Announcements
Catch up on the newest Qlik features and improvements: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Adding a six week average to a table that is going to be filtered on a WeekEnd d...

    I have a table that currently works - it allows the user to select WeekStartShipDate, which is loaded in the load script with a Floor value, filtering... Show More

    I have a table that currently works - it allows the user to select WeekStartShipDate, which is loaded in the load script with a Floor value, filtering the table to just one week:

    mikegrattan_0-1792086034865.png

     

    The variables vStartSixWk and vEndSixWk determine the date range for the 6 Week column. 

    vStartSixWk  =(WeekStartShipDate) -42

    vEndSixWk  =(WeekStartShipDate)

    The 6 Week column is then calculated as follows:

    Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6

    The % of 6Wk Total column is calculated as follows:

    Num(
    Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6
    /
    Sum(
    TOTAL
    Aggr(
    Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6,
    ShipTo
    )
    ),
    '##0.0%'
    )

    So, that all works fine until I add another dimension column, such as SalesOrder. Once I do that, the date filter breaks, and the 6 Week expressions return zeroes.

    Please advise.

    Show Less
  • forum

    Qlik Answers

    Qlik Answers - Overage

    Hello, IA is being tested by most of our customers. As everybody knows all SaaS products come with a number of free Qlik Answers questions: 25 for Sta... Show More

    Hello, IA is being tested by most of our customers. As everybody knows all SaaS products come with a number of free Qlik Answers questions: 25 for Starter, 200 for SaaS user based or Standard and 1.000 for Premium and Enterprise. This year Qlik changed the rule for overage. Only Capacity has overage enabled. All other features come with overage disabled, including Answers.

    We came across several customer using beyound their contracted limits. So we have two questions: 1 - Who and how can we flag the tenant to disable Answers overage, 2 - Are we going to receive invoices for these overages?

    Thank you 

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    NEW! Qlik Analytics Migration Tool v2.5.0

    This version adds support for migrating of Qlik Sense Task chains, adds an option to use NTLM Authentication for the Service account and introduces Si... Show More

    This version adds support for migrating of Qlik Sense Task chains, adds an option to use NTLM Authentication for the Service account and introduces Silent install.

    Task chains are displayed in a new Task tab in the Plan, allowing to edit the individual task or chain with options to split an invalid or unnecessary chain, attaching specific tasks to new or existing ones and other types of fixes.

    The Plan page tables have been enhanced to show warnings and other information, and have been grouped depending on the source, Qlik Sense, QlikView or Qlik NPrinting.

    Using NTLM for the authentication of the Service account removes the need to set a Service Principal Name (SPN), which prevented a successful installation on servers that already had somme other service already running. Other methods of authentication are still supported.

    It is now possible to perform a silent install based on a file containing all the information required for the installation, allowing for prgramatic installation.

    Qlik Analytics Migration Tool overview

    Click here to download

    Show Less
  • forum

    Management & Governance

    Qlik Sense: standalone Node.js update after a security scanner alert

    Our infrastructure security scanner flagged our Qlik Sense servers as potentially vulnerable because of the bundled Node.js 24.18.1 runtime. Following... Show More

    Our infrastructure security scanner flagged our Qlik Sense servers as potentially vulnerable because of the bundled Node.js 24.18.1 runtime. Following the October 21, 2026 Node.js security release, I tested updating that binary independently of a Qlik patch.

    A scanner finding against a runtime version does not establish that the vulnerabilities are exploitable through Qlik Sense. Product-specific impact still needs confirmation from Qlik.

    The update from Node.js 24.18.1 to 24.22.1 passed testing in our Qlik Sense Enterprise on Windows May 2026 Patch 7 environment. This is one environment's test result, not a compatibility guarantee.

    This experimental method is not validated by Qlik. Qlik's documented approach is to update the bundled runtime through a Qlik Sense upgrade. This post shares a technical test, not an official remediation recommendation. If evaluating it, use development first, a maintenance window and a recoverable full backup.

    Check the bundled version

    & "$env:ProgramFiles\Qlik\Sense\ServiceDispatcher\Node\node.exe" --version

    The full path checks Qlik's runtime rather than another Node.js installation on the PATH.

    Run the attached scripts

    1. Extract the scripts into one folder.
    2. Download the official Node.js 24.22.1 Windows x64 binary.
    3. Edit NodeUpdate.config.psd1: configure the binary, backup and log paths, and set the expected SHA256 using the win-x64/node.exe entry in SHASUMS256.txt.
    4. Open Windows PowerShell 5.1 as administrator and run the backup:
    .\01_Backup_Node.ps1

    Continue only after BACKUP VERIFIED:

    .\02_Update_Node.ps1

    Leave the Service Dispatcher running before starting the update: the script handles stopping and restarting it. Execution is local to each machine; relative paths are resolved against the configuration folder.

    Validate and roll back

    Check Hub, QMC, application access, exports, reloads, usual connectors and Qlik logs. These are suggested checks, not a claim that all were covered in our test.

    To roll back, set RestoreBackupDirectory to the exact original backup folder, then run:

    .\03_Restore_Node.ps1

    The scripts target the main Service Dispatcher runtime on Node.js 24 only. They do not update EAPowerTools, Package Cache or npm dependencies. A binary backup is not a full site backup, and automatic rollback is not guaranteed. Recheck the installed version after subsequent Qlik maintenance.

    Sources: Node.js security bulletin, October 21, 2026; Node.js 24.22.1 release notes, October 21, 2026; Qlik Support guidance, updated August 14, 2024.

    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

    Move to Qlik Cloud Analytics

    Disaster recovery in Qlik Saas

    May i know if Qlik Saas has any standard on RPO , RTO  for disaster recovery? Any backup Qlik will perform, how frequent it will happen? 
  • forum

    App Development

    Working on sheets without unpublishing, tag sheets, deploy apps: Hello data+

    Did someone check out that Qlik Sense sheet? I can't see it anymore!Did you hear your colleague ask that question into the shared office / on Teams / ... Show More

    Did someone check out that Qlik Sense sheet? I can't see it anymore!

    Did you hear your colleague ask that question into the shared office / on Teams / Slack ? Then I have a perfect extension for you: Hello data+

    On Qlik Cloud, editing a published sheet means making it private first. From that moment on, nobody else can see it, and you had better not get distracted and forget to publish it again. If the app is published to its managed space while the sheet is still "checked out", the managed version loses that sheet too.

    Hello data+ closes that gap for developers working on updates of published sheets:
    • Tag each sheet as intended to be public or private
    • Get reminded when a sheet meant to be public is still private, or the other way round
    • Clone a sheet for editing, while the original stays public the whole time
    • Sync every kind of change back to the original sheet's objects
    • Republish the managed app with one click, right from within the app

     

    The smallest unit of change is now a single object, not the whole sheet, and you work on a specially tagged copy. Take all the time you need, and deliver your updates in parts if you like.

    A version for client-managed will be available in December too.

    Motivation

    With the Data+ Suite, we care about much more than just write-back scenarios. Those familiar with my GitHub projects, Quick Table Viewer and Guided Tour Extension, will be pleased to know that LeitArt has included both in the supported package at no additional cost. And Hello data+is the next extension you don't want to miss!

    Join the early-access

    Register at https://waitlist.leitart.de and be among the first beta testers in November 2026.

     

    Show Less
  • forum

    App Development

    Trellis Cotnainer

    HelloI got a master visualization which is a combo chart with 3-bars expressions (stacked) and a line expressionsthe combo chart looks something like ... Show More

    Hello
    I got a master visualization which is a combo chart with 3-bars expressions (stacked) and a line expressions
    the combo chart looks something like this:

    ali_hijazi_0-1793347735406.png


    Now what I want is to break this chart by the top 8 accounts but the trellis is repeating the chart for all 8 accounts

    ali_hijazi_1-1793348047434.png

    I put advanced mode and added to the expressions the $(vDimSet) and in the dimension I put the following dimension:
    =Aggr(
    If(
     Rank(Sum({<[Portfolio Level 2 ID]={87}, SCENARIO_TYPE, SCNR_TYPE_ID={0}>} AMOUNT * MANDAYS_SPENT * FLG_MANDAYS_SPENT_INCL_DU), 4) <= 8,
    ACCOUNT_DESCRIPTION
    ),
    ACCOUNT_DESCRIPTION
    )

    but all in vain
    I also put the ACCOUNT_DESCRIPTION as the dimension in the trellis and moved the logic of the ranking to the expressions but trellis displays blanks or diplays 1 bar expression and repeating it as above
    i tried to put 8 distinct charts but the performance is extremely slow
    kindly advise

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Cloud Salesforce Connector: OAuth 2.0 Authentication Issues with PKCE

    Hi everyone,We are experiencing an OAuth 2.0 authentication issue when trying to connect Qlik Cloud Analytics to Salesforce using the Salesforce conne... Show More


    Hi everyone,

    We are experiencing an OAuth 2.0 authentication issue when trying to connect Qlik Cloud Analytics to Salesforce using the Salesforce connector from Add Data.

    A new Salesforce External Client App was created following Salesforce's recent security changes.

    According to Salesforce's updated security requirements, PKCE is mandatory for newly created applications, and the option to disable it is locked.

    However, the Qlik documentation instructs us to disable PKCE as part of the connection setup.

    We attempted to configure the Salesforce Callback URL using both:

    https://connector.qlik.com/auth/oauth/v2.htm

    https://connector.qlik.com/auth/oauth/v3.htm

    Both attempts failed during authentication, resulting in the following errors:

    redirect_uri_mismatch

    OAUTH_APPROVAL_ERROR_GENERIC

    We would appreciate hearing from anyone who has encountered a similar issue or has successfully established a Salesforce OAuth 2.0 connection in Qlik Cloud Analytics under the new PKCE requirements.

    Thanks in advance for sharing your experience!

     

    Show Less
  • forum

    Qlik Replicate

    Why does Optimise inserts result in duplicates?

    Hi, I have a task that will be insert only and has a high volume of changes. I read that "Optimize Inserts" in the Change Processing Tuning settings c... Show More

    Hi,

     

    I have a task that will be insert only and has a high volume of changes. I read that "Optimize Inserts" in the Change Processing Tuning settings can increase performance. However, the documentation also says that this setting can result in duplicates as shown below:

    MoeE_0-1793324386968.png

    Is this only relevant when "Apply changes using SQL Merge" is enabled alongside "Optimize Inserts"? Because we will not have "SQL Merge" enabled. Our target will be Snowflake.

     

    Help with this is appreciated. Thank you.


    Regards,

    Mohammed



    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image