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,255 members
  • 4,934 online
  • 2,036,105 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

    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

    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

    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
  • forum

    Talend Studio

    SalesforceとのOauth認証設定について

    現在、Talend Studioを使用する中、Basic認証からOauth認証へ切り替えをしようとしています。Studio内のメタデータよりTest Connectionをしているもののエラーの状態です。どこに不備があるのか教えていただきたいです。添付のとおり、Talend8を使用し、HTTP500... Show More

    現在、Talend Studioを使用する中、Basic認証からOauth認証へ切り替えをしようとしています。

    Studio内のメタデータよりTest Connectionをしているもののエラーの状態です。

    どこに不備があるのか教えていただきたいです。

    添付のとおり、Talend8を使用し、HTTP500エラーが生じます。他の項目については問題ないはずで、別のプログラムから接続処理をしたとき本パラメーターでJWTのトークン取得でき、Salesforce側にログイン履歴が正常にでています。

    Show Less
  • forum

    Data Movement & Streaming

    Expression Headers not working

    Hi Support, I have setup a data replication task in Qlik Cloud Data Integration, and I'm looking to use one of the provided expression headers to add ... Show More

    Hi Support,

     

    I have setup a data replication task in Qlik Cloud Data Integration, and I'm looking to use one of the provided expression headers to add a column to a table. However, when I use the header in the expression, I get a validation error with the following message: "The column expression is not valid: test. The attribute Q_H_OPERATION does not exist in the source dataset."

    NakulanR_0-1793315766426.png

    NakulanR_1-1793315805968.png

     

    My understanding is that the column wouldn't need to exist in the source dataset since it's meant to provide metadata of the source table rather than data of the table. This wasn't an issue when using expression headers in Qlik Replicate for the same purpose.

    The replication task has a SQL Server source and SQL Server target. The data movement gateway is version 2026.5.37.

    Please let me know if you need any further information. Any insight into the issue is greatly appreciated.

     

    Thanks,
    Nak

    Show Less
  • forum

    App Development

    Need workaround solution for exporting dynamic view chart in pdf from onprem Qli...

    Hi team, Need one suggestion in qliksense +(nprinting)We have dynamic view chart in qliksense dashboard but as we know that nprinting is not supportin... Show More

    Hi team,

     

    Need one suggestion in qliksense +(nprinting)

    We have dynamic view chart in qliksense dashboard but as we know that nprinting is not supporting dynamic views..

     

    What can be work around to extract dynamic view chart in pdf

    I tried

    1: creating a story then export
    2: sheet export as pdf
    3: extension+ mash-up

    No success with option 1 & 2
    With option 3 I achieve it, but not good and dynamic solution for all dashboard who have dynamic view charts.

     

    Thanks in advance!

     

    Regards,

    Prashant

    Show Less
  • forum

    Talend Cloud

    Upgrade Talend jobs to higher jar version without re-doing the "Publish to Cloud...

    Is there a way in Talend Cloud to upgrade a jar file version for Talend jobs without re-doing the "Publish to Cloud" from the Studio?FYI, the current ... Show More

    Is there a way in Talend Cloud to upgrade a jar file version for Talend jobs without re-doing the "Publish to Cloud" from the Studio?
    FYI, the current approach is 
        1. In Studio Modules, upgrade the jar file to higher version. e.g. log4j 2.17.1 to 2.25.4
        2. "Publish to Cloud" for all active production jobs
        3. Promote all jobs to production
    When there have dozens or hundreds active production jobs, there should be a better way than re-promoting all jobs to production (release) due to upgrading a single jar file version. 

    Show Less
  • forum

    App Development

    Selection fied's values when changing Sheet

    Français--------------------------------------------------------------------------Bonjour,ContexteJ'ai deux tables différentes (AGENT = TELJ... et PIL... Show More

    Français

    --------------------------------------------------------------------------

    Bonjour,

    Contexte

    J'ai deux tables différentes (AGENT = TELJ... et PILOTE = TPIJ...). Je produis une analyse pour les agents dans une feuille qlik et une analyse pour les pilotes dans une autre. Dans les deux feuilles, j'ai un filtre sur le Pole (TELJ_POLE et TPIJ_POLE). Ce que je souhaite, c'est que lorsque dans l'une des feuilles je filtre sur un ou plusieurs pôles, au changement de feuille, les valeurs se sélectionnent dans l'autre filtre.

    Ce que j'ai testé

    1. Appliquer l'action 'Sélectionner des valeurs dans un champ' avec la valeur :

    Concat(DISTINCT TELJ_POLE, ';')

    Cette solution fonctionne bien lorsque je sélectionne un / des pôles. Cependant, lorsque je ne sélectionne pas de Pole et que je change de feuille, toutes les valeurs se sélectionnent.

    2. Appliquer l'action 'Sélectionner des valeurs correspondant aux critères de recherche' mais je ne trouve pas de critère. Les Pôles sont du texte avec des valeurs complètement hétérogènes.

    Auriez-vous une solution à m'apporter ?

     

    English

    --------------------------------------------------------------------------

    Hello,

    Context

    I have two different tables (AGENT = TELJ... and PILOTE = TPIJ...). I create an analysis for agents in one Qlik sheet and an analysis for pilots in another. In both sheets, I have a filter on the Pole (TELJ_POLE and TPIJ_POLE). What I want is that when I filter on one or more poles in one sheet, when switching to the other sheet, the values get selected in the other filter.

    What I tried

    1. Applying the action 'Select values in a field' with the value:

    Concat(DISTINCT TELJ_POLE, ';')


    This solution is working when i select one or multiple Pole. However, when I don’t select a Pole and switch sheets, all the values get selected.

    2. Applying the action 'Select values matching search criteria' but I can’t find a criterion. The Poles are text with completely heterogeneous values.

    Would you have a solution to suggest?

    Show Less
  • forum

    Qlik Automate

    Automating Consumption Report Export to Azure Blob Storage

    Hello team,I am looking to automate our consumption report export and would like to know if the following workflow is possible:- Generate and save CSV... Show More

    Hello team,

    I am looking to automate our consumption report export and would like to know if the following workflow is possible:

    - Generate and save CSV files to Azure Blob Storage using Qlik Application Automation
    - Ingest the data into Snowflake and visualize it in Qlik Sense or Excel

    Could you please confirm if this process is feasible? If so, any documentation or guides would be greatly appreciated.

    Best Regards.

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image