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: 
  • 272,356 members
  • 9,590 online
  • 2,045,536 posts
  • 154,686 Solutions
Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!

Welcome to Qlik Community

Recent Discussions

  • forum

    Talend Studio

    Big Data Batch Spark Exit Code = 1 Caused by: java.lang.reflect.InaccessibleObje...

    i have put properties "spark.driver.extraJavaOptions", "spark.executor.extraJavaOptions" and JVM Arguments with this  --add-opens=java.base/java.nio=A... Show More

    i have put properties "spark.driver.extraJavaOptions", "spark.executor.extraJavaOptions" and JVM Arguments with this 

    --add-opens=java.base/java.nio=ALL-UNNAMED
    --add-opens=java.base/java.lang=ALL-UNNAMED
    --add-opens=java.base/java.util=ALL-UNNAMED
    --add-opens=java.base/java.lang.invoke=ALL-UNNAMED
    --add-opens java.base/java.net=ALL-UNNAMED
    --add-opens=java.base/sun.nio.ch=ALL-UNNAMED

    but job still error

    fatah16x_0-1775994907841.png

     

     

    Show Less
  • forum

    App Development

    Calling Stored procedure from Impala using shell script or bat file

    Hello All,I am looking to run stored procedure script(DB Impala) from Qlik Sense On-Prem environment using Shell Script or Bat file or any other mode ... Show More

    Hello All,

    I am looking to run stored procedure script(DB Impala) from Qlik Sense On-Prem environment using Shell Script or Bat file or any other mode and post that show the data in Qlik Sense UI. 

    Is there any way or solution to achieve this? 

     

    #!/bin/bash

    # -----------------------------

    # Impala Connection Details

    # -----------------------------

    #IMPALA_HOST="impala-hostname"

    #IMPALA_PORT="21000"

    DATABASE="kan_adhoc"

    impala_cli="impala-shell -i kancdhdatap6.kanhadoopprd.net -d default -k --ssl"

     

    # -----------------------------

    # Impala CREATE TABLE

    # -----------------------------

     

    SQL_QUERY1="DROP TABLE IF EXISTS ${DATABASE}.aca_type;"

     

    SQL_QUERY="CREATE TABLE IF NOT EXISTS ${DATABASE}.aca_type as select * from kan_ref.aca_type ;"

     

    # -----------------------------

    # Execute Query

    # -----------------------------

    #impala-shell \  -i ${IMPALA_HOST}:${IMPALA_PORT} \  -q "${SQL_QUERY}"

     

      $impala_cli -q "${SQL_QUERY1}"

     

      $impala_cli -q "${SQL_QUERY}"

     

    # -----------------------------

    # Status Check

    # -----------------------------

    if [ $? -eq 0 ]; then

      echo " Table created successfully in Impala."

    else

      echo " Failed to create table in Impala."

      exit 1

    fi

    Show Less
  • forum
  • forum

    Talend Cloud

    implementaion of three-tier model (Load data, schema, application) on Qlik clou...

    We work with Qliksense On Preim in the three-tier model (Load data, schema, application)How do you implement in the cloud?As I understand it, there ar... Show More

    We work with Qliksense On Preim in the three-tier model (Load data, schema, application)
    How do you implement in the cloud?
    As I understand it, there are 3 types of spaces:
    Shared, managed, data

    Shared – development environment

    Managed – publishing to customers

    Data – data creation and storage

    Personal – personal environment, parallel to work

    Our architecture:
    load data - shared space
    Schema – shared space
    Qvd files, excels and all data files – data space
    Applications – managed spaces

    Is this the right way?
    And do you create shared, Data and managed spaces for each environment (dev, test, prod)

    Show Less
  • forum

    Data Movement & Streaming

    Setup Qlik Cloud MCP & LLM Copilot

    Hi team,I tried to set up this LLM but currently, to make the test with Swagger on Power Automate to authorize the OAuth session, it indicates that th... Show More

    Hi team,

    I tried to set up this LLM but currently, to make the test with Swagger on Power Automate to authorize the OAuth session, it indicates that the redirect URI is not registered, and I made this in the before steps.

    Some have the same problem or know other steps to work with Qlik Cloud MCP and Copilot.

    Thanks

    Show Less
  • forum

    Management & Governance

    Seeking Validation: Backup Checklist for Upgrading to Qlik Sense November 2025 (...

    Hi everyone,I am currently preparing for an upgrade to Qlik Sense November 2025 (Shared Persistence) and am following the official Qlik Help documenta... Show More
    Hi everyone,

    I am currently preparing for an upgrade to Qlik Sense November 2025 (Shared Persistence) and am following the official Qlik Help documentation.

    Based on my review, I’ve compiled the following backup checklist. I would appreciate it if the community could validate if I am missing any critical locations or steps.

    1. Certificates

    • Full export of Qlik Sense certificates (including private keys) from the MMC (Computer Account).

    2. Repository Database Dumps (PostgreSQL)

    I plan to run pg_dump for the following databases:

    • QSR
    • SenseServices
    • QSMQ
    • Licenses

    3. File Share (Shared Root Folder)

    • Full backup of the folder specified in QMC > Service Cluster (e.g., C:\QSRoot), ensuring \Apps, \ArchivedLogs, and \StaticContent are included.

    4. Supporting Content & Configuration Files

    I have identified the following local server paths for backup. Are there any specific service-level configuration files or sub-folders I might be missing here?

    • Logs & Bundled DB Configs: C:\ProgramData\Qlik
    • Connectors & Data Connections: C:\Program Files\Common Files\Qlik
    • Service Configs: C:\Program Files\Qlik\Sense (specifically checking for modified .config files in Repository, Proxy, and Scheduler folders).

    5. Question on Centralized Logging (QLogs)

    I noticed that the February 2020 documentation mentioned backing up the QLogs database, but this is absent from the November 2025 guide.

    • Is it safe to assume QLogs is no longer required for a modern upgrade due to the deprecation of Centralized Logging, or should I still include it as a precaution?

    Any advice or "lessons learned" from those who have already moved to the 2025 releases would be greatly appreciated!

    Thanks in advance,

    Poonam

    Show Less
  • forum

    Qlik Answers

    Error DAA-016 and error request count

    Hello,I have sometimes this error in Qlik Answer (generally, when the chart agent takes the lead).Qlik Answer : A temporary processing issue occurred.... Show More

    Hello,

    I have sometimes this error in Qlik Answer (generally, when the chart agent takes the lead).

    Qlik Answer : A temporary processing issue occurred. Please try again in a moment. Reason: (Error DAA-016)

    Ok, if I retry, it works, but I notice that error request count in the administration home page.

    We should not pay if Qlik is not answer to our request.

    Regards,

    Show Less
  • forum

    Qlik Answers

    Qlik Answers - Add output to sheet

    Hi,Recently i did some research about Qlik Answer. I was impressed of what was possible and how we can add the output to sheets. Today (23/02/2026) i ... Show More

    Hi,

    Recently i did some research about Qlik Answer. I was impressed of what was possible and how we can add the output to sheets. 
    Today (23/02/2026) i cannot do it anymore. What has changes? 
    Still possible to ask questions, but after a while now is a sheet generated linked to the last questions. 

    Is there permission right changed?
    When will met generated sheets and when is this visibel? How can I add one bar sheet output to my sheet now?

    Thx.

    Show Less
  • forum

    Qlik Answers

    Qlik Answer - QVF file logic

    If I upload a qvf file will Qlik answer be able to share all the logics, source system and details from the script.
  • forum

    Visualization and Usability

    How to freeze/pin "Row Totals" column on the left during horizontal scroll in Vi...

    Hi everyone,I am facing a challenge with a Pivot Table in Qlik Sense and I was wondering if anyone has found a workaround.My Scenario: I have a Pivot ... Show More

    Hi everyone,

    I am facing a challenge with a Pivot Table in Qlik Sense and I was wondering if anyone has found a workaround.

    My Scenario: I have a Pivot Table with the following structure:

    • Rows: Product Group, Brand.

    • Columns: Day (Dynamic, e.g., Day 5, 6, 7...).

    • Measure: Sales.

    The Requirement: I need the Row Total to be displayed at the beginning (Left) of the table, and critically, it must remain frozen (pinned) alongside the dimensions when the user scrolls horizontally to see the later days.

    What I have tried:

    1. Native Pivot Table: Does not support freezing measures/totals natively.

    2. Vizlib Pivot Table: I have the full Vizlib Library. I configured the "Row Totals Position" to "Before" (Top/Left). Result: The Total column correctly appears on the left side, BUT it is not frozen. When I scroll to the right to see "Day 20", the Total column disappears/scrolls away along with the data columns.

    My Question: Is there a specific setting in Vizlib Pivot Table to force the Total column to be part of the "Frozen Pane" (like the dimensions)? Or is there a known workaround to achieve a fixed Total column on the left?

    Thanks in advance for your help!

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Customer Story

Universidad Nacional del Sur is Combining Research and Educational Data

Through the Qlik Academic Program and Qlik Sense, Universidad Nacional del Sur transforms complex data into interactive insights while preparing students for the modern workforce.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Qlik Connect 2026: Be Bold. Be Different. Be Here.

Join us April 13–15, 2026 in Kissimmee, Florida for 2+ immersive days of innovation, hands-on learning, and powerful connections shaping the future of data and AI.

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.