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: 
  • 280,008 members
  • 15,305 online
  • 2,052,413 posts
  • 155,137 Solutions
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Answers

    How to activate Qlik answers on a distributed app ?

    Hello , We are in a business context where apps are reloaded in qlik sense client managed and then pushed to Qlik cloud tenant via multi-cloud distrib... Show More

    Hello , 

    We are in a business context where apps are reloaded in qlik sense client managed and then pushed to Qlik cloud tenant via multi-cloud distribution mechanism . 

    This is working fine but we have no access to app settings in the qlik cloud tenant for a distributed app, and thus we cannot activate qlik answers on it . 

    Can someone explain if this is a design choice or just a temporary limitation ?  
    Thanks
    Thomas


    ________________________________________________________

    See the difference for a 'distributed' app 
    thomasmaure_0-1775032023867.png

     

     
    And the same app exported from QS client managed and reimported in QlikCloud tenant 
     
     thomasmaure_1-1775032023868.png

     

    Show Less
  • forum

    Qlik Replicate

    NCLOB to VARChar

    Hi Sir, We have a replica from MS SQL Server to Snowflake with numerous transform: NCLOB to Varchar.  Datatype in Source db is NVARCHAR (max) hence NC... Show More

    Hi Sir,

    We have a replica from MS SQL Server to Snowflake with numerous transform: NCLOB to Varchar.  Datatype in Source db is NVARCHAR (max) hence NCLOB in Qlik, but client in Snowflake uses different lengths for Varchar, e.g., a target table has one column Varchar(1000) and the other column Varchar(5000).  How can we achieve that in Qlik replication since Qlik doesn't support table Transform for NCLOB?

    Thanks,

    Richard 

    Show Less
  • forum

    Water Cooler

    Data Voyagers: Qlik Cloud's Visual Task Chain Viewer: A Faster Way to Debug Your...

    Hi everyone!I’m back again to recommend a video by @marksouzacostafrom Data Voyagers about the Visual Task Chain Viewer in Qlik Cloud.For anyone manag... Show More

    Hi everyone!

    I’m back again to recommend a video by @marksouzacostafrom Data Voyagers about the Visual Task Chain Viewer in Qlik Cloud.

    For anyone managing multiple chained reloads, this looks like a huge time-saver when it comes to diagnosing failures within those chains. It turned out to be the perfect solution for a project I’m currently working on that requires this type of management.

    Check out the full step-by-step video from Data Voyagers here: https://www.datavoyagers.com

    Youtube: https://www.youtube.com/watch?v=GvG_wqvMlZ0

    Has anyone else been using this tool? 🙂

    Show Less
  • forum

    Qlik NPrinting

    nprinting may 2026 fails for high dpi report output, not for normal

    hello, since may 2026 version of nprinting, my reports in high quality fail to generate with an error "object reference not set to an instance... "the... Show More

    hello, 

    since may 2026 version of nprinting, my reports in high quality fail to generate with an error "object reference not set to an instance... "

    the same report in normal quality generates without any problem... 

    any suggestions ? 

    mikaelsc_0-1780393219080.png

    mikaelsc_1-1780393282180.png

     

    already increased the rendering and scheduling timeouts

    mikaelsc_2-1780393399710.png

     

     

    Qlik NPrinting #may2026 @Ruggero_Piccoli 

     

    Show Less
  • forum

    Administering and Monitoring

    Import and Export of Qlik replicate tasks using IaC Technology (Terraform)

    We are using qlik replicate to replicate the data from sql server to kafka and gcs targets.  Currently we using the Import API's for replicate tasks t... Show More

    We are using qlik replicate to replicate the data from sql server to kafka and gcs targets. 

    Currently we using the Import API's for replicate tasks to import the tasks into replicate server and we are using jinja templates to create the task json by passing the configuration and tablenames (List of table is not static and passed at the time of json creation) and import those json programmatically (Jenkins) and as we are creating the json task on the fly using templates, we are missing the traceability, which is really a challenging as changes are not being recorded. 

    Ask here is, How can we make it more configurable manner with traceability / recoverability for each qlik task. Curious to know if someone has already done this using terraform. 

    Can this be achieved using Terraform? or any other IaC technology which help us to the onboarding qlik tasks in more configurable and manageable way.

    Consider a scenario of disaster recovery. If we are creating the json's on the file and we dont know the previous state of the task and recreating the task would be painful.

    Show Less
  • forum

    Integration, Extension & APIs

    Gitoqlok. Version Control and Time Saver for Qlik Sense.

    It’s Git O’clock for your Qlik Sense routine! Add Gitoqlok to your application development cycle and enjoy the Continuous Integration perks as well as... Show More

    It’s Git O’clock for your Qlik Sense routine! 
    Add Gitoqlok to your application development cycle and enjoy the Continuous Integration perks as well as tricks for easing your working routine.

    Gitoqlok is an easy-to-use tool for version control and collaborative development in Qlik Sense. Via integration with several Git providers (GitHub, GitLab, BitBucket, etc.), the extension opens the gates to the world of version history. Any change made in the application by the user can be tracked and restored at any point in time - milestone your work and enjoy the visual time travel between different versions of your application - and don’t switch a single window.

    Regardless of your team’s size, Gitoqlok is the remedy for the headache of conflicting changes - the git system inherited in Gitoqlok detects developers’ copies of applications, stores their changes in independent branches, and aids in detecting collisions for published applications.

    Version control is not the only offering Gitoqlok has up its sleeve. In the favor of advancing your development process by reducing manual routine work, you can:

           ✔ Immediately find an application that generates a QVD file in Data Load Editor;
           ✔ Set covers for the sheets in just a few seconds;
           ✔ Use the AI capabilities to generate Sheets and Master Measures titles and descriptions;
           ✔ Migrate Qlik objects between different Qlik environments and backup restore, and many more!

    Learn more about the whole spectrum of features on https://docs.gitoqlok.com/

    Join our Slack community https://app.slack.com/client/T012RHLTWHL

    Try Gitoqlok yourself https://chrome.google.com/webstore/detail/gitoqlok/kkgicbgpgfcbhcbmifmfagggnpkebdaj?hl=en

    Show Less
  • forum

    Qlik Replicate

    Export/Import with Git for Qlik Replicate Tasks

    Every few months I go looking for things in my company that could run smoother, and this time I landed on Qlik Replicate. So I asked the engineers and... Show More

    Every few months I go looking for things in my company that could run smoother, and this time I landed on Qlik Replicate. So I asked the engineers and consultants how they handle changes to tasks.

    In short: tasks reuse is export, import, and hand-editing the JSON in between. Version control is a folder of exported files, if someone remembered to export. Transformations stay stuck in the task they were written in. And none of it ever settles, because new sources and targets keep arriving.

    So we built a first version of Git versioning for Qlik Replicate Tasks. Here is how it works:

    1. A browser extension (Gitoqlok, iykyk) grabs the list of Replicate tasks from the console links a Git repository to it (GitHub, GitLab, Bitbucket, Azure DevOps). The task definition goes in as the first commit.

    Screenshot 2026-09-08 at 20.31.22.png

    1. Repository then contains the JSON that Replicate's Export button gives you: endpoints, table selection, transformations, task settings. Plus a README generated from it: source, target, endpoints, the table list.

    Screenshot 2026-09-08 at 20.49.27.png

    Screenshot 2026-09-08 at 22.55.00.png

    1. Change and commit. Edit the task in the console as usual. Next time you open the popup it shows what changed, line by line. Here I added one transformation on a table, and it shows exactly the 28 lines it touched. Type a message, Commit & Push.

    Screenshot 2026-09-08 at 20.52.04.png

    1. Go back. History dropdown, Restore button. Any version goes back into Replicate as a full replacement, deleted table selections included.

    So the versioning and rollback part is done. My next idea was import: a task committed from DEV gets imported into TEST or PROD straight from Git, any saved version.

    Then the sheer number of transformations inside a single task got me thinking: maybe transformations deserve versioning of their own... Imagine an import that pulls just one piece, a transformation or the logging levels, from another task you've already configured.

    Some additional details: our install doesn't have EM, so this uses the console's API.

    Would appreciate your thoughts, any feedback. If anyone's interested, I'd be happy to share the solution!

    #QlikReplicate #Qlik #DataEngineering #CDC #DevOps 

    Show Less
  • forum

    Data Quality

    FILTRE SUR UNE VARIABLE NON OPERATIONNEL

    Bonjour  j ai une condition de date dans un where qui ne marche pas j'ai essayé plein de solutions rien n'aboutit  la voici  where Date(Date#(CAPA_MOI... Show More

    Bonjour 

    j ai une condition de date dans un where qui ne marche pas j'ai essayé plein de solutions rien n'aboutit  la voici 

    where Date(Date#(CAPA_MOIS,'dd/mm/yyyy'))=Date(Date#('$(vMoisReport_Suivant)','dd/mm/yyyy'))

    ma dernière tentative est sous cette forme avez vous des idées ?

    Show Less
  • forum

    Qlik Compose

    Modelling employee history (SCD Type 2) in Qlik Compose from a custom HRMS sourc...

    Hello everyone, I work at Dev Technosys, where we do HR management software development, building custom HRMS platforms for our clients. One of our cl... Show More

    Hello everyone,

    I work at Dev Technosys, where we do HR management software development, building custom HRMS platforms for our clients. One of our clients' data teams uses Qlik Compose for their data warehouse, and they'd like HR data from our platform to feed into it. Before we finalise our database design, I'd like to understand how to make the source data as Compose-friendly as possible.

    Scenario:

    • Source: a relational HRMS database (PostgreSQL) with employees, departments, job titles, managers, locations, and compensation bands
    • Data would land through Qlik Replicate (CDC)
    • The client wants to report on employee history, for example, headcount by department at any point in time, promotion rates, and attrition

    My questions:

    1. Tracking employee history: From what I understand, attributes in the Compose model can be set to keep history (Type 2). For an employee entity, which attributes would you normally track historically (department, job title, manager, location), and which would you keep as Type 1?
    2. Source design: Is it better for our HRMS to keep its own effective-dated history tables (for example, employee_job_history with valid_from and valid_to), or should we keep the source simple with current values only and let Compose build the history from CDC changes?
    3. Backdated changes: HR data often includes backdated updates, such as a promotion entered today that was effective last month. How does Compose handle changes where the business effective date is different from the date the change was captured?
    4. Manager hierarchy: What's the recommended way to model a reporting hierarchy (employee → manager) in Compose so that historical org charts can be reconstructed?
    5. Sensitive data: Salary and personal details are sensitive. Is it better to exclude these columns at the Replicate level, or handle masking and access within the warehouse and data marts?

    Any guidance, documentation links, or experience from similar HR data projects would be really appreciated.

    Thank you!

    Show Less
  • forum

    Management & Governance

    Monitoring apps fail after enabling SSO (SAML/Entra ID)

    Hi,We're running Qlik Sense Enterprise on Windows, November 2025. Since IT enabled SSO (SAML) on the server, all monitoring apps (Content Monitor, Lic... Show More

    Hi,

    We're running Qlik Sense Enterprise on Windows, November 2025. Since IT enabled SSO (SAML) on the server, all monitoring apps (Content Monitor, License Monitor and Operations Monitor) fail to reload with the following errors.:

    Content Monitoring --> Connection 'monitor_apps_REST_app' not found

    License Monitor --> Connection 'monitor_apps_REST_license_user' not found

    Operations Monitor --> Connection 'monitor_apps_REST_user_condensed

    What we've already checked/tried, without success:

    • The data connections (e.g. monitor_apps_REST_*) exist in the QMC, correctly named, no typo.
    • No security rule has been added or modified since the SSO switch
    • All apps have been exported and reimported but still failing identically on their respective monitor_apps_REST_* connections.
    • Owner is INTERNAL\sa_repository (default, unchanged).
    • Connection string uses the default pattern: provider=QvRestConnector.exe;url=https://localhost/qrs/license/useraccesstype/full;...;authSchema=ntlm;...
    • Tested with an explicit port on the URL (:4243) — same error.
    • Checked virtual proxies: we have Central Proxy (Default) (prefix mgmt, Authentication method = Ticket, Windows authentication pattern = Windows, this field is grayed out/system-managed) and Entra ID (SAML, no prefix). The default proxy already natively supports the Windows authentication pattern fallback, so it doesn't look like a virtual proxy/NTLM config issue.
    • Temporarily created a dedicated virtual proxy (Windows-only, separate prefix) to isolate REST/API traffic from the SSO flow — same "Connection not found" error persisted, so we rolled it back.

    Has anyone met this ? if you could help please

    BR,

    Hamid

     

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image