Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 240,772 members
  • 3,278 online
  • 2,023,473 posts
  • 152,168 Solutions
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Installing and Upgrading

    Do we really need the SSL Certificate during installing QWC?

    Do we really need the SSL Certificate  during installing QWC?Creating an SSL certificate for the Qlik Web Connectors | Qlik Connectors Help Is there a... Show More

    Do we really need the SSL Certificate  during installing QWC?
    Creating an SSL certificate for the Qlik Web Connectors | Qlik Connectors Help

    Is there any bullet point steps to install QWC?

    i.e.

    • Open port 5555 on the QWC server and all the Qlik Sense Central & Rim nodes
    • Has to be Window 2022 server
    • 4 core cpu & 16GB RAM
    • Do not install in Program Files folder
    • .......

     

    Show Less
  • forum

    New to Qlik Analytics

    How to aggregate items within the same measure in a bar chart

    I want to show per month a stacked bar chart collecting as measure the turnover of several geographical areas.There are so many geographical areas tha... Show More

    I want to show per month a stacked bar chart collecting as measure the turnover of several geographical areas.
    There are so many geographical areas that it would be convenient to aggregate some areas in groups, like North, East, South, and West.

    How to get the stacked bar chart with the area groups instead of the singular area?

    Any hint?

    AdrianoEllero_0-1736879606555.png

    chart with all areas ungrouped 

     

    Show Less
  • forum

    Integration, Extension & APIs

    Issue with X-Qlik-Session-keycloak Cookie Persistence After Logout in React Appl...

    Hello everyone, I am working on a React web application that logs into a Qlik page embedded within an iframe using Keycloak's OIDC method for authenti... Show More

    Hello everyone,

    I am working on a React web application that logs into a Qlik page embedded within an iframe using Keycloak's OIDC method for authentication. However, I've encountered an issue with cookie persistence after logout. Specifically, even after logging out from the React application, the X-Qlik-Session-keycloak cookie remains stored, causing problems for subsequent users who log in. This issue persists unless the browser is completely closed and reopened.

    Has anyone faced a similar problem or know of any configuration settings in Qlik that can help resolve this issue? Any guidance or suggestions would be greatly appreciated.

    Thank you!

    Show Less
  • forum

    Deployment & Management

    System requirements for Qlik Web Connectors - July 2024

    Hi We are planning to deploy a Windows 2022 server for Qlik Web Connectors - July 2024Qlik Web Connectors Release Notes - July 2024 Rele... - Qlik Com... Show More

    Hi

    We are planning to deploy a Windows 2022 server for Qlik Web Connectors - July 2024
    Qlik Web Connectors Release Notes - July 2024 Rele... - Qlik Community - 2472479

    So what are the recommended Windows Server resource requirements?

    # of CPU cores

    RAM

    Drive size recommendation. Any recommendation for log folders.

    We will connect it with our multinode Qlik Sense Enterprise for Windows - February 2024 P5 environment.

    Show Less
  • forum

    Integration, Extension & APIs

    Integrating Qlik Sense with Keycloak OIDC for SSO in a React Application

    Hello Qlik Community, I am working on integrating Qlik Sense with Keycloak for Single Sign-On (SSO) using OIDC. I followed the steps in this Official ... Show More

    Hello Qlik Community,

    I am working on integrating Qlik Sense with Keycloak for Single Sign-On (SSO) using OIDC. I followed the steps in this Official Support Article, and I was able to set up OIDC login into Qlik Sense successfully.

    Here is the current setup:

    • React Application: The frontend is a React web client.
    • Authentication: Using Keycloak for authentication, and the React app uses Keycloak Connect for Node.js.
    • Server: Node.js Express application.
    • SSO Requirement: Users logged into the React app should also be logged into Qlik Sense without being prompted to log in again.

    Problem: Despite following the setup instructions, when a user navigates to the Qlik Sense page from the React application, they are prompted to log in again. I need a solution where the user can seamlessly access Qlik Sense without having to log in again if they are already authenticated in the React app.

    Additional Information:

    • Keycloak and Qlik Sense are configured with TLS and use self-signed certificates.

    Questions:

    1. How can I achieve seamless SSO between the React application and Qlik Sense using Keycloak?
    2. Are there specific configurations or additional steps required to ensure the SSO works without additional login prompts?
    3. Is there a way to pass the Keycloak token from the React app to Qlik Sense to maintain the user's session?

    Any guidance or suggestions would be greatly appreciated. Thank you!

    Show Less
  • forum

    App Development

    Can Someone Please Help...

    Hi everyone - I have the following script that I'm using to create a mapping table giving me Master_Id by maximum campaign date. What I'm trying to do... Show More

    Hi everyone - I have the following script that I'm using to create a mapping table giving me Master_Id by maximum campaign date. What I'm trying to do is load all the logins from the login table where the Master_ID is within the mapping table. It must be something to do with a where clause but I can't seem to get it right. Can anyone out there please help?

    //Creates the campaign date mapping table to link to logins
    CampaignDateMap:
    Mapping LOAD Distinct
        %Master_Id,
        Num(Max(CampaignDate)) as CampaignDate  
    Resident CampaignContacts
    Where Email_Open = 1
    Group By [%Master_Id];
     
    ///////////////////////////////////////////
    LoginsTemp:
    LOAD *
    FROM [lib://CUSTMKT VIS - QVDs/2.Transformed\T_ENG_LOGINS_MDM_CLICKSTREAM.qvd](qvd);
     
    Thanks in advance
    Show Less
  • forum

    Integration, Extension & APIs

    QRS externalProgram Tasks (Chaining, Editing)

    hello all, I attended Qonnections 2019 "QRS API"  session which, although i'd say that i have sufficient experience with QRS calls, dropped a huge "hi... Show More

    hello all, I attended Qonnections 2019 "QRS API"  session which, although i'd say that i have sufficient experience with QRS calls, dropped a huge "hidden" nugget that I wanted to double click on

    ExternalProgramTask

    I created a simple external task that triggers a bat file.

    {
    "path": "C:\\Users\\<MYUSERHERE\\Desktop\\makedir.bat",
    "name": "MakeDirectory3",
    "taskType": 1,
    "enabled": true,
    "taskSessionTimeout": 1440,
    "maxRetries": 0,
    "privileges": null,
    "impactSecurityAccess": false,
    "schemaPath": "ExternalProgramTask"
    }

    currently I see a couple of issues

    1)

    When I go to the QMC-> Select the task and click edit

    qmc external call.PNG

    This implies that I cannot chain the task or schedule it using QMC. Are there any QRS that could accomplish these  as a workaround?

     

    2) Similiarly If I want to chain a reload app task to the completion of the external task , It gives me an error ( note that this is just me trying things out, the first issue is the one i would want to work with)

    qmc chain .PNG

    I am using Qlik Sense November 2018 Patch 4

    @Levi_Turner  any chance  for you to confirm whether these two are real issues or simply not implemented yet ?

    Show Less
  • forum

    App Development

    Iterative CDC issues with Qlik Sense

    Hello all, I am working on a project where I am trying to switch a bunch of Qliksense QVDs from full nightly reloads to change data capture reloads (C... Show More

    Hello all,

    I am working on a project where I am trying to switch a bunch of Qliksense QVDs from full nightly reloads to change data capture reloads (CDC), where only new data (identified by a Primary Key) from our base table (in databricks) will be inserted/updated into a QVD where all the data is stored. 

    The current QVD stored via QlikSense feeds off of a base DLT (delta live table) table from databricks. However, we now want to implement CDC and not do a FULL reload every night to save money on clusters costs.

    Only new data identified by a BOL_UPD_DT field from said base DLT in databricks will be loaded (added/concatenated) to the existent QVD. The BOL_UPD_DT field  is a timestamp that allows me to identify if an existing row has been newly updated or newly inserted).

    My goal is to use the BOL_UPD_DT and Primary Key (PK) from said base DLT table to scope out new data that will make it to the QVD. Both base table and QVD have the same named fields. My issue is - How do I carry out the following steps (via data load editor):

    1. Select new data (CDC) from base table based on "LastExecTime" and "BeginningThisExecTime" of the QVD reload. 

    2. Load the data from the existing QVD.

    3. Join the CDC data from the base table (in step 1) with the loaded data from QVD (in step 2) using their Primary Key (PK) and insert new data into the QVD if the data is new or update existing data in the QVD

    How does one script this??????

    Qlik-sense does a lot of things intuitively and seemingly doesn't give one refined process control per CDCs; so far for the 3 steps laid out above I the following pseudo script-wise:

    ===============

    Let LastExecTime = ConvertToLocalTime(ReloadTime(), 'Place/TimeZone');
    Let BeginningThisExecTime = ConvertToLocalTime(now(), 'Place/TimeZone');
    Let LastExecTime = reloadtime();

    // Loads data from QVD

    LOAD   

    PK,
    BOL_UPD_DT,
    c,
    d,
    e

     

    //Isolate Primary Key for join use using unqualify function

    qualify *;
    unqualify PK;

    // Select newly updated or inserted data from base table

    SELECT

    PK,
    BOL_UPD_DT,
    c,
    d,
    e

    FROM base DLT
    WHERE BOL_UPD_DT >= #$(LastExecTime)#
    AND BOL_UPD_DT < #$(BeginningThisExecTime)#;

    =====================

    //Next for new QVD inserts I tried:

    Concatenate LOAD * FROM QVD 
    WHERE NOT EXISTS(PK);   

    // did not work. QVD data load editor did not even save/compile because mistake in the script. 

    I need some help here....

    Show Less
  • forum

    Design and Development

    Request for Assistance - Databricks JDBC Load Issue in Talend 8 with Java 17

    Hello Talend Support Team, I am encountering a persistent issue when trying to load data from Databricks via JDBC in Talend 8 using Java 17. Below is ... Show More

    Hello Talend Support Team,

    I am encountering a persistent issue when trying to load data from Databricks via JDBC in Talend 8 using Java 17. Below is a brief summary of the problem and the steps I have already taken:

    Environment & Setup:

    • Talend 8 (Studio version 2024-10)

    • Java 17 (HotSpot JDK 17.0.11)

    • Databricks JDBC driver 2.6.40

    • Connection string (example):

      bash
      Copy code
      jdbc:databricks://adb-3178472978883225.5.azuredatabricks.net:443/default
        ;transportMode=http
        ;ssl=1
        ;httpPath=sql/protocolv1/o/3178472978883225/1218-184617-zyvhht5e
        ;AuthMech=3
        ;UID=token
        ;PWD=<token>
        ;EnableArrow=0;
      
      

    Error Description: When attempting to run a job (tDBInput or similar component) that queries Databricks, the job fails with an InaccessibleObjectException. The relevant part of the error log reads:

    vbnet
    Copy code
    Exception in thread "main" java.lang.ExceptionInInitializerError
    Caused by: java.lang.IllegalStateException: java.lang.reflect.InaccessibleObjectException:
      Unable to make java.lang.invoke.MethodHandles$Lookup(java.lang.Class) accessible:
      module java.base does not "opens java.lang.invoke" to unnamed module @xxxxxx
    
    

    We have already:

    1. Added all standard -add-opens lines to our Talend .ini file, including:and verified the .ini content.

      csharp
      Copy code
      --add-opens=java.base/java.lang.invoke=ALL-UNNAMED
      --add-opens=java.base/java.nio=ALL-UNNAMED
      --add-opens=java.base/java.lang.reflect=ALL-UNNAMED
      ...
      
      
    2. Restarted Talend and confirmed the environment is using Java 17.

    3. Tried setting EnableArrow=0 in the connection string to avoid Arrow-based reflection issues.

    4. Checked that other Talend jobs (not connecting to Databricks) run fine under the same Java version.

    5. Attempted to ensure the same VM arguments are applied both in Talend Studio and when exporting/running the job externally.

    Despite these measures, the reflection error persists specifically for the Databricks connection. We suspect the required --add-opens are not being fully honored, or there is a conflict between the Databricks driver’s reflection calls and Talend’s module settings under Java 17.

    Request for Assistance: Could you please advise on:

    1. Any additional configuration or patches needed for Talend 8 to handle Java 17 reflection with Databricks JDBC?
    2. Best practices for ensuring -add-opens flags are applied to jobs that use the Databricks driver, particularly when run from the Talend Studio or CommandLine/Talend Management Console.
    3. Any known compatibility issues or additional driver settings that might resolve this error.

    I greatly appreciate your help. If you need more logs or environment details, please let me know. Thank you in advance for your guidance on this matter.

    Best regards,

    Lukas Hruska

    Data Engineer

    NN Group Slovakia

    Show Less
  • forum

    Deployment & Management

    Resizing and reposition the legend on chart manually not working

    Resizing and reposition the legend on chart manually not working -  while trying to resize the  legend  and changing the position of chart manually no... Show More

    Resizing and reposition the legend on chart manually not working -  while trying to resize the  legend 

    and changing the position of chart manually not working as expected.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

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

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!