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

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?

chart with all areas ungrouped 

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!

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!

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?

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....

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

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.