Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We are tried to add one of the field that has mixed data types and when it comes to enterprise the the text is showing ion the left alignment and num is right alignment which is an expected scenario but when we are trying to load same set of data on the Qlik cloud its treated everything as a text and showing as left alignment.
is there a way to fix this issue without using dual function?
Regards,
Raju
We are currently evaluating Qlik Replicate (Attunity) as a solution for replicating data from various RDBMS systems (e.g., Oracle, MariaDB, PostgreSQL) directly into Iceberg tables in an S3-based data lake. We are seeking clarity on whether Attunity offers native support for writing directly to Iceberg tables without intermediary steps or reliance on other query engines like Snowflake.
Background: Our goal is to enable seamless replication from RDBMS systems into Iceberg-backed tables in S3. We aim to simplify our architecture by directly writing to Iceberg tables, leveraging Glue or other catalogs for table management.
Questions:
Why This is Important: Direct integration with Iceberg would eliminate dependencies on intermediary systems, streamline our data replication process, and align with our Lakehouse MVP initiative.
We would appreciate any guidance, documentation, or recommendations regarding direct Iceberg integration.
Thank you!
Hi,
I'm wondering if there is a similar PDF guide for tuning to an Azure Synapse target as there is for the Databricks guide that I found online (attached)
Regards,
Mohammed
Hello Everyone,
It appears that Qliksense does not support creating a second level of grouping within the grouping sheet feature.
For instance, if I have a total of three sheets, I want the first sheet to be part of Group A and the second sheet to be part of Group B. I would like the third sheet to be part of a subgroup under Group A. However, currently, this functionality is not available. While I can create multiple groups, I cannot create a group within a group. Could you please confirm if this is a bug or if there is a way to achieve this?
Thank you.
Hi Thanks for the article
I have the following error, i reviewed the following steps
1) ZIP file, are no locked,
2) The zip file path is generated by firefox browser (file://///192.168.2.67/Produccion/Staging/Dimensiones/ArchivosTabla/Shapefile_Poligonos_AMVA.zip)
3) The windows qlik account services has full control over ZIP Folder file
4) The Qlik GeoAnalytics Connector are licensed with Geo Analitycs Server License
hey everyone,
i have created a simple rest api in Talend that load some informations from a mssql database.
If i run this Job in Studio, it works for me:
But when i'm export the Job to the cloud and deploy the task and test it in the api tester, i get the error message "com.microsoft.sqlserver.jdbc.SQLServerDriver cannot be found by c360.Systems_0.1.0"
Where is my mistake?
Thanks and best regards
Patrick
Hey all,
i am facing the following challange. Given is the following sample data:
contract_id | contract_year | payment_year | payment |
ABC | 2019 | 2019 | $ 1000 |
ABC | 2019 | 2020 | $ 250 |
ABC | 2019 | 2021 | $ 2000 |
ABC | 2019 | 2023 | $ 250 |
ABC | 2019 | 2024 | $ 2500 |
XYZ | 2021 | 2021 | $ 100 |
XYZ | 2021 | 2022 | $ 250 |
XYZ | 2021 | 2024 | $ 1200 |
These are contracts and in almost every year there is a payment regarding a given contract (>> payment year).
I want to create a pivot table that looks like this (the columns after Year ist the field payment_year):
contract_id | contract_year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
ABC | 2019 | $ 1000 | $ 250 | $ 2000 | $ 2000 | $ 250 | $ 2500 | $ 2500 |
XYZ | 2021 | $ 0 | $ 0 | $ 100 | $ 250 | $ 250 | $ 1200 | $ 1200 |
The challange is as follows:
Is there any way to do this with minimal scripting effort ? i have built a solution by creating fake records for every missing payment year per contract but this a very imperformant (> 90M contracts) and resulted in a lot of script which is hard to maintain. Is there a lean way of achieving what i am after ?
Thanks in advance!
Is it possible to distribute a given value like 50.000, across a range of yearmonths (sorted in ascending order), following a bell curve distribution, directly in the frontend in a table?
example
load * Inline
[
year_Calendarmonth
202401
202402
202403
202404
202405
202406
]
;
vTestinput = 50000;
I had an issue where i could not start my QlikNPrintingmessagingservice service after installing the lattest windows paches.
I managed to eventually restart this service using info in
It baffles me that this occurs and had to be manually resolved...
However still none of my tasks works or restarted and all reports and caching holds showing 'running' or queued now for several hours.
https://localhost:4993/#/tasks/executions
How could I force to stop all (old) running tasks as the abort button or action does not respond at all ?
Trying to stop a task will result in a no-sense message :
Attendees get two free certification exams included with their event registration (valued at $500).
Qlik Reporting Service received a significant upgrade with several new features!
Join us 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!