Dear Experts,

We are getting below error while running data ware house task in qlik compose:
"SYS,GENERAL_EXCEPTION,COMPOSE-E-STARTFLD, Failed to start task "FL". View log file for more details"

And there is nothing written inside the log file.

Any solution?

Hi Team,

Is it possible to provide a row-level security on a specific sheet in Qlik SaaS. 
For example, Consider Regions Field, In Sheet1 I would like to see all regions data but in the sheet2 I would like to restrict it for a specific region for respective region users.

Thanks in Advance for your reply!

Best Regards

Hi Qlik Community,

I’m working on a pivot table in Qlik Cloud and trying to implement a background color expression for highlighting monthly min and max values — only for the Category "Sales".

My Setup:

Dimensions:

1. BUSINESS_DATE_MONTH_YEAR → format: YYYY_MM

2. Week_Year → format: YYYY_WEEK

3. [Final Formatted Date] → format: D-DAY-MMM-YYYY

Category Values: Only two – Sales and Encashment

Expressions:

Expression 1:

Background Color:

Expression 2:

Background Color:

Expression 3:

Background Color:

Requirement:

I want to highlight the max value in blue and the min value in red (per month) only for "Sales" Category in Expression 1.

My Current Background Color Expression for Expression 1:

Problem:

• Only the min value is getting highlighted in some months.

• Max value is not getting highlighted at all.

Question:

How can I fix the expression to correctly highlight min (red) and max (blue) values for each month only when Category = 'Sales'?

Any help would be appreciated!

Hello community,

I am tryting to use qlik cloud trial verion for edcation and practicing qliksense at home as a part of my personal learning. I have created a new account and tried to loging but it is saying like 'No tenants to manage'. T have also created one talend account and used the same email id to login the Qlik account but still facing the same. How to get into the qliksense hub. Anybody, please help

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

I suspect the issue is caused due we store in pg the timestamp without timezone ( data type is just timestamp and not timestampz) and this is an example of data content :  2025-03-11 14:09:24

Could it be the root cause ? I understand that if we dont store the +1 during the winter and we dont store the +2 during summer, postgres wont be able to detect the diference during DST changes? that makes sense to me, but does make sense to qlik replicate?

Does Qlik Replicate is able to recognize de data from Oracle source with local time zone as UTC? (as it is stored in reality in oracle source)

Hi,

Is there any way to move 1.1TB Qvd files from Amazon S3 Bucket to Qliksense SAAS Library without downloading and uploading.

Thanks

Sumanta

#Qliksense#QVD

Hi there,

I am trying to develop traffic light gauges within a straight table that bases colours off 'Category' rather than hard coded values.

Anyone had any luck achieving this?

Hello Experts.

I am currently working with Qlik Replicate 2024.11,
and I have a question regarding the Log Stream Staging (LSS) task when working with SQL Server as the source.

In my scenario, an active transaction is already in progress when the LSS task is started.
The logs indicate the following output:

---
[SORTER] I: Transaction consistency. Start from oldest transaction (sorter_transaction.c:349)
---

From this, it appears that the task begins capturing changes from the oldest transaction that was already in progress.

My question is as follows:
1. Does Qlik Replicate guarantee that the task will always capture from the oldest transaction in such cases?
2. Is there a possibility that long-running, uncommitted transactions will not be captured by the LSS task?

I would appreciate your clarification on how the transaction consistency is handled when starting an LSS task with SQL Server as the source, especially with respect to active and uncommitted transactions.

Thank you for your assistance.

Regards,

Kyoko Tajima

Hi Support,

We encountered this error while running a task

Not authorized to object JRN_NAME in JRN_LIB.
RetCode: SQL_ERROR SqlState: 58004 NativeError: -443 Message: [IBM][System i Access ODBC Driver]SQL0443 - Not authorized to object JRN_NAME in JRN_LIB.
Failed(retcode-1) to execute statement: 'SELECT sequence_number FROM TABLE (QSYS2.Display_Journal('JRN_LIB','JRN_NAME ')) as J LIMIT 1

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20iSeries/required_permissions_iseries.htm

Our DBA has followed the official permission settings, but the above error still occurs. Currently, the error is resolved only if the File Authority is set to *ALL.

We would like to confirm why such a high level of authority is required and whether there are alternative permission settings that can be applied to resolve this issue.

Looking forward to your guidance.

Hello,

I've tried to generate a mail with 6 reports (using the Reporting option in Qlik Cloud working with the Excel Add-in).

When I send it to one users, the number of reports is incremented +6 (which seems OK)

When I send it to 4 users (including an external user), the number increment +12. I don't understand it 🙂 
Can someone explains me how it works ? 

Regards