Hi Qlik Support Team,

We have the following questions:

1. Is there a way in Qlik Replicate to use the column as the column to filter, at the same time exclude it from the output. We tried this setup and encountered the following error:
Setup:

    - In Transform, all columns are included except the column used for filtering

    - The same column used in filter. column_name == "value"

Error:

Table 'schema'.'table_name' (subtask 1 thread 1) is suspended. Cannot compute expression, not all column values are in the data record.

2. For using the column for filtering, referencing the column name is typed as $column_name. Is there a way to call the source column or is $column_name the only way to reference the column names for filtering.

Thanks!

Suppose I have a employee data. First I generate the QVD's. When i start to perform incremental load on QVD's using API's so i want only change data add in the QVD based on employee ID.
How to solve this problem?

Hi,

We have a task that picks data from oracle source to postgres target. During the DST Daylight Saving Time last weekend of March 2025, it seems the data in the postgres target is still in winter time (1 hour + utc ) and it should be 2 hour + utc. And we need to do a full reload to make the dates show properly.

I checked the documentation it looks the DST wont impact unless we were in the midle of a full load during the change or scheduling.

https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/DST%20Change/dst_impact.htm

This is not our case, we just ran the task for months without touching anything. The DST change happens while CDC is running.

The data type  in oracle source is TIMESTAMP WITH LOCAL TIME ZONE, replicate picks by default as string and we cast as datetime(6) in qlik replicate, in postgres the data type is TIMESTAMP

Could it be the root cause? and if that the case why?

I get a request to reload the SAP table LIKP table as it is out of sync.  One engineer will send me a query from SAP and the same from the datalake and I can see missing data.  Again once I run a reload the issue goes away.  The customer has raised this to management as it has happened multiple times.  Can someone point me to any documents or log files that I can review to see where the error occurred?

Version of Qlik Replicate is -> November 2024 (2024.11.0.177)

Here's a list of CSS modifications that used to be common, but no longer are necessary as there are styling settings and other functions that are easier to use and maintain.

Hi All,

I have a measure that returns the date of the earliest gift given by a person (ID) with the unique identifier 'PAT':

=Min({<UNIQUE IDENTIFIER]={'PAT'}>} [DTE])

Now, I would like to create a measure that returns the date of the earliest gift made AFTER the one calculated above for the same person (ID). To do this, I am trying to Aggregate by ID within set analysis as follows:

=Min({<[DTE] = {">$(=Aggr(Min({<[UNIQUE IDENTIFIER]={'PAT'}>}[DTE]),[ID]))"}>} [DTE])

However, this results in null values for every ID.

I find this strange since when I test the Aggr() function outside of a Set Analysis, it returns the date I expect. But when I put it in the Set Analysis, it results in the Preview looking like:

=Min({<[DTE] = {">-}>} [DTE])

Does anyone know why this is? Is Aggr() not allowed within Set Analysis?

Thank you very much for any help!

Hello,

Not sure if there is a difference in QlikView to Qlik Sense for Set Analysis. The example below should force the filter to always select the flag 1 and 0 regardless of a user interacting with the IsInNetwork filter then adjust the total to the other filters such as date or region or sales person.

sum({<IsInNetwork={'1','0'}>}Quantity)

If I set to this I get and the user updates the IsInNetwork filter the total changes to the selected flag to sum({$<IsInNetwork={'1','0'}>}Quantity)

Hello All,

I would like to learn the capabilities of Qlik Sense environment and I would like to create a simple Qlik Sense React Mashup which will show just one object in my web application. I have made some research for this purpose but I could not succeed to find a working sample.

My installation is Qlik Sense Enterprise on Windows. So the application I want to develop is not for Cloud (SAAS) environment. 

Any help, documentation, sample or direction will be appreciated. 

All the best.