Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,238 members
  • 4,230 online
  • 2,023,981 posts
  • 152,221 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • forum

    Move to SaaS

    Data Types issue when compared to Enterprise and SaaS Cloud

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

    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

     

    Show Less
  • forum

    Qlik Replicate

    Inquiry: Direct Replication from RDBMS to Iceberg Tables in S3

    We are currently evaluating Qlik Replicate (Attunity) as a solution for replicating data from various RDBMS systems (e.g., Oracle, MariaDB, PostgreSQL... Show More

    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:

    1. Does Attunity currently support direct replication from RDBMS to Iceberg tables in S3?
    2. Are there native connectors or configurations available for this use case, particularly for Glue-backed Iceberg catalogs?
    3. If such a connector exists, are there any specific setup instructions, limitations, or prerequisites we should be aware of?

    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!

    Show Less
  • forum

    Qlik Replicate

    Is there a tuning guide for Azure Synapse target?

    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 (atta... Show More

    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

    Show Less
  • forum

    App Development

    Grouping sheets in Qliksense - level 2 and 3

    Hello Everyone, It appears that Qliksense does not support creating a second level of grouping within the grouping sheet feature. For instance, if I h... Show More

    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.

    Show Less
  • forum

    GeoAnalytics

    Qlik GeoAnalytics Error loading ESRI Shape File

    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 b... Show More

    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

    mherrera_0-1737406960338.png

     

     

    Show Less
  • forum

    Design and Development

    SQLServerDriver cannot be found

    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 fo... Show More

    hey everyone,

    i have created a simple rest api in Talend that load some informations from a mssql database. 

    patrickkahle_0-1736520490020.png

    If i run this Job in Studio, it works for me:

    patrickkahle_1-1736520676379.png

    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"

    patrickkahle_2-1736521110255.png

     

    Where is my mistake?

     

    Thanks and best regards

    Patrick

     

     

    Show Less
  • forum

    App Development

    (Tricky?) Scripting Question

    Hey all, i am facing the following challange. Given is the following sample data: contract_id contract_year payment_year payment ABC 2019 2019 $ ... Show More

    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:

    • my data has gaps. meaning: not every contract has a payment in every year up until current year, but i need to display consistent years as above
    • where there is missing data after the first payment i need to populate the payment with the previous year's payment until a new record with payment (red colored amounts)

     

    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!

    Show Less
  • forum

    App Development

    Create a Bellcurve in a yearmonth Table with a inputvariable

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

    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;

    Show Less
  • forum

    Design and Development

    cFile component and scheduler error on Talend Administratio Center

    Dear support, I set a cFile component with the scheduler :   from("file://C:/temp/testscheduler" + "?noop=false" + "&autoCreate=false" + "&flatten=fa... Show More
    Dear support,
    I set a cFile component with the scheduler :
     
    from("file://C:/temp/testscheduler" + "?noop=false" + "&autoCreate=false" + "&flatten=false" + "&bufferSize=128"
    + "&scheduler=quartz" + "&scheduler.cron=*+*+1-23+?+*+*" + "&antInclude=*.xml" + "&move=done"
    + "&moveFailed=error")
     
    and when I launch it from the local Talend Studio it works properly, but when I deploy it into the Talend Administrator Center I got the error :
     
    2025-01-20 10:19:31.068 WARN [Blueprint Event Dispatcher: 1] Changing Camel state for bundle 1812 to Failure
    2025-01-20 10:19:31.069 ERROR [Blueprint Event Dispatcher: 1] Error occurred during starting CamelContext: mdw.testfilewithquartz_0_4.TestFileWithQuartz
    org.apache.camel.FailedToCreateRouteException: Failed to create route TestFileWithQuartz_cFile_3: Route(TestFileWithQuartz_cFile_3)[From[file://C:/temp/testsc... because of Failed to resolve endpoint: file://C:/temp/testscheduler?antInclude=*.xml&autoCreate=false&bufferSize=128&flatten=false&move=done&moveFailed=error&noop=false&scheduler=quartz&scheduler.cron=*+*+1-23+%3F+*+* due to: Cannot load org.apache.camel.pollconsumer.quartz.QuartzScheduledPollConsumerScheduler from classpath. Make sure camel-quartz.jar is on the classpath.
     
    I did another test with another component that use the same library in the same route and it works.
     
    In details I configured a cMessagingEndpoint with :
     
    URI : "quartz://myGroup/myTimerName?cron=0+0+1+1+1+?+2099"
    Advanced settings --> Camel component : "quartz"
     
    and both locally and on the TAC start without error.
     
    Maybe in the cFile component I should specify the quartz library, but how? Or is there something else to configure?
     
    Thanks in advance,
    Andrea De Pinto
    Show Less
  • forum

    Qlik NPrinting

    I cannot abort running tasks in NPrinting

    I had an issue where i could not start my QlikNPrintingmessagingservice service after installing the lattest windows paches. I managed to eventually r... Show More

    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 

    https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-NPrinting-messaging-service-and-the-Qlik-NPrinting/ta-p/1711303

    and https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm 

    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 

    andries_bos_0-1737371302809.png

    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 :

    andries_bos_0-1737379773805.png

     




    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!