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,

However: with power point, NPrinting does not allow me to change the connection when importing the report.

Is this a normal limitation for PowerPoint reports in NPrinting?

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:

1. Is there an official way to declare a measure as semi-additive in Business Logic?

2. Can Business Logic reliably express something like “use the last value in the period” for a measure?

3. Should this be handled exclusively through a master measure expression (e.g., FirstSortedValue()) instead of Business Logic?

4. 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!

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】

1. 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?

2. 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.