Hi All,

Can you please help me understand how to resolve below 

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

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?