Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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.
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:
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:
Questions:
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 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
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)
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 ?
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:
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
...
Restarted Talend and confirmed the environment is using Java 17.
Tried setting EnableArrow=0
in the connection string to avoid Arrow-based reflection issues.
Checked that other Talend jobs (not connecting to Databricks) run fine under the same Java version.
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:
-add-opens
flags are applied to jobs that use the Databricks driver, particularly when run from the Talend Studio or CommandLine/Talend Management Console.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.
Celebrate your team's excellence! Applications are now open for a chance to be recognized on our global stage.
Qlik Reporting Service received a significant upgrade with several new features!
Join us on Jan. 15 for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!