Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 266,232 members
  • 5,745 online
  • 2,047,277 posts
  • 154,385 Solutions
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY error on Databricks target endpoint

    Hello,I’ve configured a Log Stream task to read from a Microsoft Azure SQL database, along with a replication task that reads from this Log Stream and... Show More

    Hello,

    I’ve configured a Log Stream task to read from a Microsoft Azure SQL database, along with a replication task that reads from this Log Stream and replicates data to a Databricks Lakehouse (Delta) endpoint.

    Both tasks were running correctly until this week, when I stopped and resumed them for maintenance on the Qlik Replicate server.

    After resuming the tasks, the replication task started logging the following error for all tables, and replication is now suspended for each of them:

    Failed (retcode -1) to execute statement: CREATE OR REPLACE  TABLE `schema_name`.`table_name` ([fields]) USING DELTA LOCATION 'abfss://location_for_tables' TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true)
    RetCode: SQL_ERROR  SqlState: 42KD7 NativeError: 80 Message: [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: [DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY] com.databricks.sql.transaction.tahoe.DeltaAnalysisException: The specified properties do not match the existing properties at abfss://location_for_tables.
    
    == Specified ==
    delta.autoOptimize.optimizeWrite=true
    
    == Existing ==
    delta.autoOptimize.optimizeWrite=true
    delta.enableChangeDataFeed=true

    The Databricks target endpoint is configured with the internal parameter $info.query_syntax.create_table, using the following statement:

    CREATE or REPLACE ${TABLE_TYPE} TABLE ${QO}${TABLE_OWNER}${QC}.${QO}${TABLE_NAME}${QC} ( ${COLUMN_LIST} ) USING DELTA TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true)

    I then tried adding the missing property to match the existing table metadata, but the same error still occurs. Specifically, I tested the following statement:

    CREATE or REPLACE ${TABLE_TYPE} TABLE ${QO}${TABLE_OWNER}${QC}.${QO}${TABLE_NAME}${QC} ( ${COLUMN_LIST} ) USING DELTA TBLPROPERTIES (delta.enableChangeDataFeed=true, delta.autoOptimize.optimizeWrite = true)

    I even tried removing the internal parameter entirely, but the same error continues to occur.

    Is there a supported way to force Qlik Replicate to recreate the tables (or align with existing ones) while preserving or explicitly setting the missing property?

    Any guidance or best practices for handling this scenario with Databricks targets would be greatly appreciated.

    Thank you very much in advance for your help.

    Best regards

    Show Less
  • forum

    Chile

    Número de filas de una API utilizando conector REST

    Hola Fabián, tengo la siguiente consulta: me conecto a una API utilizando el conector REST, pero siempre me trae solo 100 registros, sabiendo que hay ... Show More

    Hola Fabián, tengo la siguiente consulta: me conecto a una API utilizando el conector REST, pero siempre me trae solo 100 registros, sabiendo que hay más de mil. Y como 100 es un número "cerrado" pienso que puede ser algún tipo de seteo de Qlik que no puedo encontrar. ¿Me puedes ayudar?

    Show Less
  • forum

    Management & Governance

    NEW! Content Monitor for Qlik Sense Enterprise on Windows

    The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing admini... Show More

    The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing administrators to understand the evolution and origin of specific behaviors of the platform.

    • Basic information can be found in Content Monitor | help.qlik.com  
    • Each sheet in the Content Monitor includes an About text box to describe its content. 

    This new monitoring app comes pre-installed with the latest version (November 2025 onwards) of Qlik Sense Enterprise on Windows.

    If you are running previous versions of Qlik Sense Enterprise on Windows, the Content Monitor is also available on Qlik's Downloads page here: Content Monitor (download page) - note, this must be manually installed and a weekly reload is recommended.

    Show Less
  • forum

    Connectivity & Data Prep

    Service Now Connection Spinning forever- Qlik Sense Feb 2024 SR17

    Hi All, Our firm's is on Qlik Sense Enterprise Feb 2024 SR17, with issues extracting data from our Service Now cloud SaaS instance. We are able to con... Show More

    Hi All, 

    Our firm's is on Qlik Sense Enterprise Feb 2024 SR17, with issues extracting data from our Service Now cloud SaaS instance. We are able to connect successfully to the Service Now database, however when trying to select a Schema (Actual) and the DB view its spinning endlessly and wont even release the window when cancelled.

    The below is inside the Data load editor Service-Now data selector window. The Service now URL has been allowed listed in the QMC aswell and servers rebooted.

     

    Can anyone suggest on how to proceed further to debug this issue? 

     

    RajaDumpa_0-1765833693878.png

     

     

    Show Less
  • forum

    Do More with Qlik

    Qlik Automate Templates - Taking Action on Your Data - Part 5

    This is the 5th and final part in the "Taking action on your data series" -  It recaps the the four basic action types that can be achieved with Qlik ... Show More

    This is the 5th and final part in the "Taking action on your data series" -  It recaps the the four basic action types that can be achieved with Qlik Automation and Qlik Cloud Analytics and shows you how others can reuse your automations by creating them as templates. 

    Resources:

    See this link for all previous episodes and resources.

    Show Less
  • forum

    Qlik Automate

    404 error on Get Space

    Hello,We are trying to use Qlik Cloud Services within Qlik Application Automation. Some blocks work correctly and pass the domain in the URL as expect... Show More

    Hello,

    We are trying to use Qlik Cloud Services within Qlik Application Automation. Some blocks work correctly and pass the domain in the URL as expected, but others do not. For example, we receive the following error when using the Get Space block. We are not sure if we are missing a configuration or setting. Appreciate any help. Thanks.

    radhakrishna2331_1-1765572305544.png

     

    radhakrishna2331_0-1765572212756.png

     

    Show Less
  • forum

    App Development

    Help Optimizing an expression with AGGR

    Sum(Aggr(max( {<GLaccountCode={'121001','117000'}>}If((YearEndDate>=NetDueDate and [Clearing Date]>YearEndDate and Arrears>0) or AROverdue='Overdue',A... Show More

    Sum(Aggr(max( {<GLaccountCode={'121001','117000'}>}If((YearEndDate>=NetDueDate and [Clearing Date]>YearEndDate and Arrears>0) or AROverdue='Overdue',ARAmountLC)
    ),YearFilter,ARKey))

    Above is my expression i use on charts and its very slow when there are no filters.

    I'm using an As-of table and when i apply filters inside the if-clause, the amount is duplicated(guessing its due to many-to-many joins) and I'm forced to use Max() inside the AGGR() function.

    My data model looks like below,

    akash_durai1507_0-1765828964363.png


    TIA,

    Show Less
  • forum

    App Development

    Sheet title font colour / style (Qlik Sense November 2025)

    Hi, how change sheet title font colour / style in Qlik Sense November 2025?I swear I was able to do this in the 2022 version, then I didn't use it for... Show More

    Hi, how change sheet title font colour / style in Qlik Sense November 2025?

    I swear I was able to do this in the 2022 version, then I didn't use it for a long time and now I can't find this option, and what I found on the forum is probably not up to date.

    Sebastian_Dec_0-1765825243082.png

     

    I

     

    Show Less
  • forum

    Management & Governance

    Download as Image / PDF does not work

    Qlik Sense Enterprise on Windows November 2025 Patch 1Cannot export charts as images or pdf files.Added settings in Printing.exe.config:<add key="webr... Show More

    Qlik Sense Enterprise on Windows November 2025 Patch 1

    Cannot export charts as images or pdf files.

    Added settings in Printing.exe.config:

    <add key="webrenderer-args" value="-l=trace" />

    <add key="webrenderer-grpc-call-timeout-secs" value="300" />

     

    [2025-12-15 21:23:59] serving url: https://myserver/resources/assets/mapconf.json from file system provider for prefix /resources/, file path: C:\Program Files\Qlik\Sense\client\assets/mapconf.json
    [2025-12-15 21:23:59] successfully downloaded resource from local path: C:\Program Files\Qlik\Sense\client\assets/mapconf.json for url: https://myserver/resources/assets/mapconf.json
    [2025-12-15 21:23:59] PaintHandler::OnResourceLoadComplete id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df worker=worker_47_1w url=https://myserver/resources/assets/mapconf.json?1765826639052&xrfkey=LlbQsjiygAtNzqI5 bytes=87 response_status=OK
    [2025-12-15 21:23:59] PaintHandler::OnBeforeResourceLoad id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df worker=worker_47_1w url=https://maps.qlikcloud.com/ravegeo/webmap5/maps?key=may21-K8DU2D3jU9PWhr&listMaps method=GET
    [2025-12-15 21:24:58] exit due to timeout id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df
    [2025-12-15 21:24:58] processed request id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df valid=false render_msec=60012
    [2025-12-15 21:24:58] error, LoadAndRenderChart failed id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df error=task LOAD_URL_TIMEOUT, result: ERROR_LOADURL_TIMEOUT_RESULT, the rendering page could not be loaded, check the URL

    Show Less
  • forum

    Water Cooler

    Ready, Set, Go! Our First Qlik Community Savenger Hunt is LIVE!

    Welcome to our first-ever Qlik Community Scavenger Hunt! We’ve hidden secret letters all around the Community, and each clue below will point you towa... Show More

    Welcome to our first-ever Qlik Community Scavenger Hunt! We’ve hidden secret letters all around the Community, and each clue below will point you toward a different location in the navigation. Follow the trail, collect every letter, and crack the final phrase to reveal the mystery phrase. Submit your answer for a chance to score some exclusive prizes!

    Ready to get started? Here's some helpful tips:

    • Ad and Pop-Up Blockers can block the clues, disable them to participate
    • When searching.... be patient! It might take a second for the letter to load.
    • Look around for the letter on the page, they can be found anywere on in the white space of the page 
    • Use the comments in this post for help or ping us!
    • Please do not post the answer in the comments
    • Note: You must be logged into your Qlik Community account in order to participate

     

    Now, for the fun! Here are the clues. Good luck!

    1. Find the group where women speak, their stories strong, their spirits unique.
    2. Not grounded by wires, not stuck in the ground— Find the forum where your data’s future is cloud-bound.
    3. Where innovation is set in motion, and this new solutions blog stirs the ocean.
    4. Not the present, not the now— find the forum where old discussions take a bow.
    5. Where chit-chat flows (like water, hint hint!) and topics vary, From tech to fun and community commentary.
    6. To uncover your next letter, navigate to the hub that maps every Qlik event across the globe.
    7. New roles await with every scroll, Find where Qlik jobs are the goal.
    8. If you need answers, tools, or tips, visit the hub where all Qlik resources sit.
    9. From learners fresh to seasoned pro, this blog helps your knowledge grow.
    10. Each month, a featured name takes the stage, recognized for insight well beyond their age
    11. For walkthroughs, demos, and technical flair, look where users do more and share.
    12. Look for the notes that track what’s new, what’s fixed, and what’s improved—your letter lives among the new release updates.
    13. For academic users to see, this program makes Qlik learning free.
    14. Where bright ideas get a spark, and suggestions leave their mark, go here to see what this program is about.
    15. Looking for answers? I’m the bar that loves questions — click the 🔍 icon to find me! Hint: the icon is on the homepage or find a similar button above
    16. It’s not a trophy or a like, but it tells the world: ‘This one’s right! Submit answer to riddle here Hint: You can find the answer on this post but be sure to submit the answer using the link above
    17. See a post that echos your own? Click this to say "You're not alone!" Submit answer to riddle here Hint: You can find the answer on this post but be sure to submit the answer using the link above

     

    Do you have all the letters? 

    Submit the final phrase here 

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Afcons Boosts Efficiency with Qlik

Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.

Customer Story

Enhancing Customer Experience Through Smarter Insights

By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.

Customer Story

Breaking Down the Data Bottlenecks

Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.