Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
Using QlikSense February 2022 release patch 15 and while creating oracle data connection I have enabled the Use Bulk Reader option in the Oracle data connection and configured the Max String Length parameter to 16384 to handle large text fields efficiently. Reload time is faster . But I need suggestion whether it's correct approach or not ? If not then what can be followed?
Regards,
Koushik
Hello everyone,
I’m encountering a behavior in Qlik NPrinting that I don’t fully understand, and I’d like to know whether it is expected or if I’m missing something.
Here is the situation
I export a report from N Printing
Then I import it into another Nprinting App with another connection
it is well working with Excel reports, I am able to change the App and assign a new Connection without any issue
However: with power point, NPrinting does not allow me to change the connection when importing the report.
For context:
I duplicated the original Qlik Sense application, created a new NPrinting App and Connection, and attempted to reuse the same PowerPoint report template — but NPrinting prevents changing the connection during import.
Is this a normal limitation for PowerPoint reports in NPrinting?
And if so, is there any recommended workaround to reuse PowerPoint templates across different N Printing Apps/Connections?
Any insights or explanations would be greatly appreciated.
Hi Women Who Qlik,
Data Voyagers has 2 new podcasts available, both recorded recently at the Lund Meetup.
The first is an in depth conversation with Qlik CEO Mike Capone around Qlik’s journey from its Scandinavian origins in 1993 to its present as a global leader in data and AI. Mike reflects on how Qlik’s mission evolved from helping people see the whole story in their data to enabling intelligent, autonomous decision-making across the enterprise.
You can listen HERE.
The second Qlik Partner Ambassadors @igoralcantara and @Aklidas sit down with Luminaries @VParsons (NHS Foundation Trust) and @Henri_Rufin (Radiall) for an open and unfiltered conversation about analytics, data practice, challenges, use cases, and the evolving role of Qlik.
You can listen HERE.
Happy Listening!
Hi all,
I’m trying to properly configure a semi-additive measure in Qlik Sense Cloud using Business Logic so that Insight Advisor interprets it correctly when users ask natural-language questions.
Use case:
I have a metric representing number of subscribers at the end of each period (end-of-month snapshot).
This value must not be summed over time.
When a user asks something like “subscribers per month”, the correct behaviour is to return the last available value within each month, not the sum of all daily values.
What I’ve done so far:
Defined the field as a Measure in Business Logic
Associated it with a Calendar Group (date, year, month)
Tested different default aggregations (sum, max, etc.)
Tried using Business Logic behaviors for default time periods
However, Insight Advisor still tends to treat the measure as additive, depending on the phrasing of the question. It sometimes returns aggregated values instead of end-of-period values.
Questions:
Is there an official way to declare a measure as semi-additive in Business Logic?
Can Business Logic reliably express something like “use the last value in the period” for a measure?
Should this be handled exclusively through a master measure expression (e.g., FirstSortedValue()) instead of Business Logic?
Are there any recommended patterns or examples for modelling end-of-period / snapshot metrics so that Insight Advisor interprets them correctly?
Any guidance, examples, or best practices would be very helpful.
Thanks!
SINCE QLIK DOESNT GIVE A DAM FOR BETTER OBJECTS ON DATA VISUALIZATION AND WE ARE ALMOST FORCED TO USE ANYCHART OU VIZLIB. I WOULD LIKE TO KNOW OTHER OPTIONS ON EXPANSIOS PACKS. CAN YOU HELP ME?
Hi All,
Tired with a lot of options to place the values as like as SAP values "0,000000000000E+00" but here in the Databricks Delta lake house on GCP am getting as NULL values.
Changed the data type to int8, unit8, Real8, String(50) and Wstring (50) but still am getting NULL alone.
Kindly check and say anyone faced this type of issue.
We are experiencing two severe issues while performing Full Load and CDC replication using Qlik Replicate (Version: V2025.5.0.247) from MySQL (Source) to SQL Server (Target). We would appreciate any insight into the potential causes and solutions for these problems.
1. Critical Crash During Full Load
The replication task is repeatedly crashing during the Full Load phase with a critical Windows exception.
Error Type: EXCEPTION_ACCESS_VIOLATION
Involved Thread: SOURCE_UNLOAD thread
Analysis: Backtraces strongly suggest the involvement of the MySQL ODBC 8.0 Unicode Driver (myodbc8w.dll). This crash occurred multiple times after resuming the task.
【Question】 Are there any known issues or conflicts regarding the MySQL ODBC 8.0 (Version 08.00.0032) when used with Qlik Replicate (V2025.5.0.247)? What are the recommended stable ODBC driver versions, or would switching to a native connector be a better solution for stability?
2. Recurring Bulk Apply Failures in CDC (Performance Issue)
After the Full Load completes, during the Change Data Capture (CDC) phase, the task frequently fails to perform bulk updates for a specific table, resulting in significant performance degradation.
Affected Table: iims'.'tigi_damage_base (Id=84)
Error: Bulk apply operation failed and repeatedly reverted to the slower one-by-one mode for updates.
Related Warning: During the Full Load of another table (iims.tigi_damage), an invalid timestamp value ('1900-01-00 00:00:00.000000000') was detected and converted to NULL.
【Question】
What are the likely root causes (e.g., target side constraints, indexing conflicts, or Replicate internal settings) that could lead to the bulk apply failure and forced fallback to one-by-one mode for the iims'.'tigi_damage_base table?
Could the warning about the invalid timestamp value in a related table, iims.tigi_damage, indicate an underlying data quality issue that might be contributing to the Bulk Apply failures?
Thank you in advance for your assistance.
Hi, seven days ago I was able to read shared files from OneDrive using the OneDrive Metadata connector, but now it can’t find any shared folders. Neither the Metadata connector nor the OneDrive connector is working for shared folder, only My Files are visible.
When I access OneDrive directly, I can see and open the shared files without any issue, but they don’t appear in Qlik.
It’s strange because everything was working fine a week ago, and nothing has changed on my side. Do you know if there’s been any update in Qlik or OneDrive that could be causing this?
In the Metadata connector, only one file appears, but in OneDrive, I can see two additional files and five folders.
Hello everyone,
im not sure if i connect my data in the right way. i have data with different granularity for example
3 fact tables and some dimensions (20). i tried different solutions like partial link tables (attached), full link tables and the qlik default syn key without changing anything (probably cartesian problem) but my numbers are still wrong in set analysis.
My last approach was the partial link table. So far it doesnt work properly. i cant Sum values correctly.
Some info on the tables:
fact_actualpoints: key1 (composite of department,period,person,unit),actualpoints, some more columns
fact_employee: key2 (composite of department,period,person), some more columns
fact_targetpoints: key3 (composite of department,unit),targetpoints, some more columns
linktable: key1,key2,key3,department,period,person,unit
dimensions are connected with facts and other dimensions (star schema)
department has multiple units. units have different targetpoint values
my set analysis Sum(aggr(count(distinct person)*max(targetpoints),unit))
i have an example in a qvf-file with reduced data. Its maybe a fundamental thing or my model is totally wrong.
i would appreciate your help and thoughts about the data model.
thanks in advance!
Hi everyone,
I'm exploring the integration of the Qlik Assistant into my existing Qlik Sense Analytics dashboards to provide in-context assistance for users.
I understand this can be achieved using Qlik Embed. Has anyone successfully done this? If so, could you share any tips, code snippets, or best practices for the embed process?
Thank you in advance.
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Register between December 1–7 and stack an extra $150 off on top of the existing $500 early bird savings. Use code: CYBERWEEK.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader.
With Qlik Public ILT Passport, embark on live sessions with our top trainers — helping you grow faster and get the most out of Qlik. See where your passport can take you.
Take advantage of this ISV on-demand webinar series that includes 12 sessions of detailed examples and product demonstrations presented by Qlik experts.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
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.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
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.