Hello everyone, 

I have a table that lists products and their sales volumes over the last twelve months rolling. 
Kinda looks like this:

Now when I select a customer, the products that have not been purchased during the last twelve months by that customer disappear. In the example above, the second record would hence not show up anymore. Is there a way to keep those records in the table? Simple ticking the "show null values" sadly does not do the trick.

Thank you in advance for all your answers. 

Details & Context

1. Creation Method: I created the new time dimension directly on a sheet and saved it as a Master Item (Dimension).

2. Dimension Name: 3 sec (as seen in the screenshot attached).

3. Dimension Formula: The dimension is a calculated field based on the base date/time field DateUtc.

   • Formula: =Time(Floor(DateUtc * 24 * 60 * 60 / 3) * 3 / (24 * 60 * 60), 'hh:mm:ss')

4. Publishing Status:

   •  

   • The Sheet containing the chart is published.

   • The App is published to a Shared Stream.

5. User Experience: Other users see the chart object and the dimension labels (3 sec), but the chart body is completely blank or empty.do you know why?thx 

I want to use the method below to limit the range of number in chart expression, but it can‘t limit the range of number successfully. 

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-advanced-searches.htm

This is my test data:

Hi 

I have Below table where I have FY and contribution how do I get prev yr Contributions 

I have created a table another table that has below data... but not sure rather than creating another table is there another smart way of achieving above table 

My main goal is 

• To create Combo chart 
• Bars to show sum of contributions $ (current and previous) over 5 FY 
• Line to show growth rate as = (latest yr $ - prev yr$) divide prev yr$

Im experiencing a weird situation in qliksense where,
When I select a condition in my table,

=YearEnd>=NetDueDate

 Qliksense always returns both positive and negative cases.(Video attached.)
The data is not getting filtered.

To give you a background,
I'm using an As-Of table(Report_Calendar) to calculate rolling sum of Amounts.
To calculate overdues, I'm comparing 
1. YearEnd field from As-of table with NetDueDate in my fact(AccountsReceivable).
2. Clearing Date from my fact to YearEnd field in As-of table.

These conditions when used in set analysis were not returning expected results.
So I tried running the conditions individually and noticed this weird behaviour.

My data model looks like below,

 Any help would be appreciated.

TIA,

Hi,

I want to show a horizontal bar inside each cell of a Straight Table in QlikView, like the screenshot below.

What is the correct way to build in-cell progress bars in QlikView Straight Tables?

Thanks!

Hi.  I am playing with the table recipe features.  I have a QVD with some date fields.  I want to create a week calendar based on the end of the week.  So I'd like a way to create a new field that is the end of the week for each date.  I can't find a function to do that.  Can anyone suggest how to do that?

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.