Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Before I start:
Talend Open Studio for Data Integration v8.0.1.20211109_1610
Windows 10
Java 17.0.8.7-hotspot
jtds driver
I am trying to Guess Schema for a tDBInput (Microsoft SQL Server) component. I get the missing library dialog, but there is no way to download the missing jar file.
I have a good connection to the internet as I am able to download and install other libraries. Just this one fails. Not even sure why I am getting this dialog on v8.0 as it does not happen with v7.3.
Hi, everyone!
My last question was about making partitions from one QVD to several smaller.
And kind user Brunobertels sent me a link to a post, how to do automatic partitions.
And now, I have many pratitioned QVD-files and task:
I have to load those QVD-files which have only data by asked dates in ODAG request.
I just made a next script:
//first check if it's not an ODAG request, but a common load from current window
if '$(odagActive)' = '' then
set 'odag_Date' = '''01.07.2019''';
end if;
[Tasks]:
LOAD
TaskID,
ContactID,
CompanyID,
CreationDate,
TaskExpDate,
EditDate,
TaskStatus,
CreatedUserID,
ResponsibleUserID,
TaskName
FROM[lib://DataFiles/CRM_Tasks_*.qvd](qvd)
where Match(CreationDate,$(odag_Date));
But as you can see, it's a bad script, coz it loads all the files(((
Please help me to load exact files with dates which was requested.
Here's my QVDs:
lib://DataFiles/CRM_Tasks_m01_y2019.qvd
lib://DataFiles/CRM_Tasks_m02_y2019.qvd
lib://DataFiles/CRM_Tasks_m03_y2019.qvd
lib://DataFiles/CRM_Tasks_m04_y2019.qvd
lib://DataFiles/CRM_Tasks_m05_y2019.qvd
etc till the end of 2020.
Hi all,
i have the following two tables:
Contracts:
ContractID | Valid_From | Valid_To | Risk |
123 | 2003-01-01 | 2003-12-31 | A |
123 | 2003-01-01 | 2003-12-31 | B |
123 | 2003-01-01 | 2003-12-31 | C |
123 | 2004-01-01 | 2004-12-31 | B |
123 | 2004-01-01 | 2004-12-31 | E |
Risks:
Risk | Risk_Name |
A | Risk_A |
B | Risk_B |
C | Risk_C |
D | Risk_D |
E | Risk_E |
I am seeking a way to transform the two table into one table with the following structure:
Result:
ContractID | Valid_From | Valid_To | Has_Risk_A | Has_Risk_B | Has_Risk_C | Has_Risk_D | Has_Risk_E |
123 | 2003-01-01 | 2003-12-31 | Yes | Yes | Yes | No | No |
123 | 2004-01-01 | 2004-12-31 | No | No | No | Yes | Yes |
Of course the Contract table contains multiple ContractIDs with different periods. I am aiming for a result table that contains for every given Valid_From / Valid_To the information whether any of the possible risks is included.
Thanks in advance for some help here!
Hello,
I have been working on integrating an Angular application with Qlik Sense. The objective is to establish a connection, create an application, set up the script, reload the data, and build a sheet containing a chart.
However, I have encountered an issue with chart creation.
The chart is being created, but it doesn't appear within the designated sheet.
I have used enigma.js. and below is the code snippet I have utilized to generate the sheet and the pie chart:
async function createNewAppAndLoadData(global: any, newAppName: string): Promise<any> {
// Create a new app
const newApp = await global.createApp({ qAppName: newAppName });
// Open the newly created app to get the full app object
const openedApp = await global.openDoc(newApp.qAppId);
console.log('Opened app:', openedApp);
const scriptContent = `
TempTable:
Load
RecNo() as ID,
Rand() as Value
AutoGenerate 100;
`;
// Set the script of the opened app
await openedApp.setScript(scriptContent);
console.log('Script set on the opened app');
// Reload the opened app
await openedApp.doReload();
console.log('Reload complete for the opened app');
const newSheet = await openedApp.createObject({
qInfo: {
qType: 'sheet',
},
qMetaDef: {
title: 'My new sheet created',
},
});
console.log('New sheet created:', newSheet);
const sheetId = newSheet.id
console.log('New sheet created:', sheetId);
const chartDef = {
"qInfo": {
"qType": "piechart"
},
"qHyperCubeDef": {
"qDimensions": [
{
"qDef": {
"qFieldDefs": ["ID"],
"qSortCriterias": [
]
},
}
],
"qMeasures": [
{
"qDef":{
"qDef": "=Sum(Value)"
}
}
],
"qInitialDataFetch": [
{
"qLeft": 0,
"qWidth": 10,
"qTop": 0,
"qHeight": 100
}
]
}
};
const chartHandle = await openedApp.createSessionObject(chartDef);
console.log(chartHandle);
const chartLayout = await chartHandle.getLayout();
console.log(chartLayout);
await openedApp.doSave();
console.log('App saved');
return openedApp;
}
Can somebody help me?. 😀
Hello everyone,
I have a problem with a Qlik Sense app on Qlik Sense Enterprise for windows.
After having edited the app "the whole day", I needed a final edit for the day, and suddenly the script doesn't show up.
It's just showing the ring of doom.
Anyway, the app "works" - in that I can reload it from the QMC. So the Script is "there" - but just not showing up.
Mind you, the full script is about 18000 rows.
I can see the data model, and I can see the fields in the sheet view. The only thing I can't see is actually the script.
Other apps work just fine.
Anything I can do, or should I just throw away the whole app and re-do it?
Any solution would be appreciated...
/Jörgen
Hi all,
We are planning to upgrade to qlik sense enterprise edition of November 2023 ,can anyone please confirm whether this upgrade will works fine on postgres version of 12.5 or upgrade to the 14.8 is required?
Regards,
Raju
Sys overview:
# Windows Server 2022 Standard
# QS Enterprise on Windows - February 2024 and November 2023 (initiall releases)
This is what I get.
screen
I've attached the log from PostgreSQL 14:
# it seems that PostgreSQL 12.5 is installed fine
#... but PostgreSQL 14 failed for some reason ...
any ideas ?
Hi All,
I'm facing the following challenge in Qlik Sense.
I have a filter pane with different filtering options, some of them are master dimension (created in the sheet editor).
I'm trying to create a button that selects an available option in this given master dimension (not a field).
Master dimensions are not showing up under button - action - select .. - fields (because I guess they are not fields).
Anyone have any kind of workaround for this issue?
Thank you in advance!
While creating an source end point of SAP Application in Qlik Replicate, I am getting the following error:
Note: I have added sapnwrfc.dll file in environment variables also still I am facing the same issue. Also, same issue appeared for me in QCDI.
Source: On-Prem SQL server
Target: Azure SQL server
We are copying 196 tables from source to target. For whole night it was running fine. Full load and Change processing was perfect over a night.
Suddenly we encountered this error.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!