Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please help me understand how to resolve below
| ID | Name | Date | Product |
| 123 | John | 1/1/2023 | TV |
| 234 | John | 2/1/2024 | TV |
| 345 | John | 2/2/2024 | TV |
| 456 | John | 3/4/2024 | TV |
| 567 | John | 3/6/2024 | Speaker |
I have to create two columns in above table with two conditions
Condition 1 - If John buying TV after one year from initial purchase and the next purchase after one year from last purchase then its New purchase but if he changes Product like Speaker in the same Year then its New ,if not Existing - Always initial purchase is New
Condition 2 - If John buying TV or Speaker after one year from initial purchase and the next purchase after one year from last purchase then its New purchase if not Existing - Always initial purchase is New
Results Like below
| ID | Name | Date | Product | Condition 1 | Condition 2 |
| 123 | John | 1/1/2023 | TV | New | New |
| 234 | John | 2/1/2024 | TV | New | New |
| 345 | John | 2/2/2024 | TV | Existing | Existing |
| 456 | John | 3/4/2024 | TV | New | New |
| 567 | John | 3/6/2024 | Speaker | New | Existing |
Thanks in Advance!
Instale la última versión de Qlik Sense en mi nuevo servidor, las conexiones a SAP todo marcha bien,
al igual que el licenciamiento y demás; pero al crear la conexión de GoogleDrive apesar de que puedo
crear la conexión sin detalle, al momento de querer leer un sheet me marca error 403; aparentemente es por
temas de compatibilidad de v2 a v3.
Adjunto las imagenes, agradezco puedan apoyarme a resolver este tema.
Ask Michael what’s kept him connected to Qlik since 2012, and he’ll tell you it’s simple: the people. From his first days as a QlikView developer to his role today, he’s found inspiration, support, and shared curiosity in the Qlik Community, a place that’s helped him grow while empowering others to do the same. It’s that spirit of continuous learning and contribution that makes Michael our November 2025 Featured Member!
Over the years, Michael has seen Qlik evolve from QlikView to the powerful analytics platform it is today, and he’s been right there growing with it. “The Qlik Community has been the best resource I’ve come across for learning all things about Qlik,” he shares. “An engaged community is underappreciated among BI software, and the Qlik Community has helped me immensely over the years.”
Michael embodies what it means to be a rising star, someone who continues to learn, contribute, and light the way for others through his curiosity and collaborative spirit.
Outside of work, Michael enjoys following baseball, riding his motorcycle, reading science fiction, and playing video games with his kids, a mix of hobbies that reflect both focus and imagination.
Michael, thank you for bringing your curiosity, energy, and drive to the Qlik Community. Please join us in celebrating Michael as our November 2025 Featured Member and leave a comment below!
@mgranillo @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Brett_Cunningham
hi all,
I have Source as oracle and target as Databricks Delta tables on GCP. Here Qlik not support for the Cloud native function as Data enrichment function in the 2024 and 2025 Version.
So i added one column manual at the target DBRX end as Current_timestamp.
ALTER TABLE vvv ADD COLUMN audit_created_datetime TIMESTAMP;
ALTER TABLE vvv SET TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported');
ALTER TABLE vvv alter column audit_created_datetime set default current_timestamp();
But here when i get full load using Qlik replicate i need Current timestamp and when ever i got INSERT i need the col audit_Created_Datetime as current_timestamp values.
Even i add as Replace column value as audit_Created_datetime as datetime('now', 'UTC'). i got NULL in the column kindly give the solution.
I am relatively new to the Qlik universe and am setting a data model up in Qlik Sense, but really struggling to get it linking correctly, without circular references.
The tables/fields in question are:
Sales - ProductID, SalesSource, CustomerID, SalesValue
Product - ProductID, CategoryLevel1, CategoryLevel2
Targets - SalesSource, CustomerID, CategoryLevel1, CategoryLevel2, SalesTarget
The problem is with linking both Sales and Targets to Product via different fields when the 2 are linked themselves (or in a concatenated fact table, as I have it at the moment). I've tried various versions of link tables and synthetic keys, but can't get it working correctly.
Any suggestions/pointers please?
HI Team,
Currently Qlik replicate child task is enabled with Stored changes only for CDC processing.
We are keeping global policy from Apply conflicts and using Upsert mode(for duplicates and inserts not found).Can we change this to Task policy for Stored changes.
Incase Global handling policy is needed, then still do we need upsert mode to be existed.
Will it cause delay(latency) while writing entries to attrep_changes table in Databricks.
Currently we are seeing latency while writing cdc data through Insert/SQL merge queries from Qlik->to s3->Databricks.
From error handling perspective between qlik-> databricks delta, Please let us know the recommendation for Apply Conflicts in this case.
Source:MS Sql server(MS-CDC)
Target:Databricks Delta
Thanks,
Sudarsan K
Hi,
I try to setup a connexion from an HFSQL database in a qlikcloud environnement.
The QlikDataGateway is correctly installed, and the appropriate driver is available on the QDG Server.
When i test a connexion with this driver outside Qlik Environnement (in an excel file), i can retrieve data. So i believe the driver part is ok.
Now, in a qlik application. i created a connexion :
- I chose the appropriate driver in the dropdown
- In Database specific properties, i chose "Custom SQL syntax"
- when I clic on Detect button, the field Database and owner have filled up
- then i create the connexion.
When i want to use this connexion, the database part is ok, but the dropdown in Owner field are all white just as the table list (not empty, but white...) . And when i select ( blindly) a table, i have this error 'Command tables returnes not success : Arithmetic operation reulted in oberflow'.
I think there are some missing parameters in the Database specific properties part but i don't know what exactly.
Does anyone know the correct settings for this type of database?
Hi All,
After upgrading Qlik NPrinting from September 2019 to February 2025 SR1, we encountered an issue where reports are not sent to some user emails. The tasks run successfully, but some emails fail to deliver with the following error message:
20250714065008 Error Failed to send email for user 'XXXXXXX' {XXXX-XXXX-XXXX-XXXX-XXXX}. ERROR: 4.3.2 Concurrent connections limit exceeded. Visit https://aka.ms/concurrent_sending for more information. [Hostname=server.outlook.com]
Previously on NPrinting September 2019, all reports were sent without any issues.
We have contacted support and already tried adjusting the following parameters in the scheduler.config file as suggested in the release notes:
max-mail-client-connection-attempts: (default is 2)
mail-client-connection-attempts-delay-ms: (default is 500 ms)
Despite these changes, the problem persists. We’re unable to ask the SMTP admin to change server-side settings, especially since everything worked fine before the upgrade.
Has anyone else experienced this issue after upgrading? Any advice or workarounds would be greatly appreciated.
Thanks
Hi Qlik experts and Qlik Support,
We have a situation were on the server hosting the installation of Qlik Sense Enterprise Windows (May 2024), an installation of Postgres version 18 was carried out and now thUnknowing Upgrade of Postgres to version 18 on Qlik Sense Enterprise Windows - May 2024e Qlik Sense hub and QMC not coming up. At first, did not know about the installation/upgrade of the Postgres (as well node.js) by another team for some other dev purposes.
Can anyone advice what are my options? Even if I have to carry out a fresh installation on another server, is it possible to get the qvf files or any other settings from the environment despite not being able to open either of the hub and qmc.
I will also try to get the last log files and attach if that can provide more context
Thanks
Regards,
Ayodele
Hi,
I am trying to create a table like below, where Actuals and Forecasts are shown in the same table. Users will be able to compare forecasts made in different months with the Actual numbers and compare which of the multiple forecasts was more accurate.
Appreciate any help with how to build the model to achieve this. I have attached sample data used in creating this table.
Regards,
BS
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Turn data into bold moves: unlock new ways to drive data, AI, and business forward at Qlik Connect.
The Qlik Product Recap spotlights the latest features, plus a short demo and shareable resources to help you stay current and make the most of Qlik.
Making a platform decision for 2025? See why IDC named Qlik a Leader in BI and Analytics.
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.
Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.
Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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.