Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Creation Method: I created the new time dimension directly on a sheet and saved it as a Master Item (Dimension).
Dimension Name: 3 sec (as seen in the screenshot attached).
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')
Publishing Status:
The Sheet containing the chart is published.
The App is published to a Shared Stream.
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.
This is my test data:
Hello Support Team,
I hope you are doing well.
I noticed that the following endpoints were listed in the May 2025 Support Matrix but are missing from the November 2025 Support Matrix.
Could you please let me know if there are plans to support these in the November version?
[Missing Endpoints]
Snowflake on AWS (S3 storage)
Snowflake on AWS (Snowflake storage)
Snowflake on Azure (Azure Blob storage)
Snowflake on Azure (Snowflake storage)
Snowflake on Google (Google Cloud Storage)
Best Regards.
Hi
I have Below table where I have FY and contribution how do I get prev yr Contributions
| Financial Year | Contributions$ | prev yr Contributions$ |
| FY 2025/2026 | 10 | 20 |
| FY 2024/2025 | 20 | 30 |
| FY 2023/2024 | 30 | 40 |
| FY 2022/2023 | 40 | 50 |
| FY 2021/2022 | 50 | 0 |
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
| Financial Year | Previous FY Year |
| FY 2025/2026 | FY 2024/2025 |
| FY 2024/2025 | FY 2023/2024 |
| FY 2023/2024 | FY 2022/2023 |
| FY 2022/2023 | FY 2021/2022 |
| FY 2021/2022 | FY 2020/2021 |
My main goal is
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】
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.
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.