We have an application that reads cdc data from IBM DB2 source and writes to kafka target. There is a calculcated field defined for a table in table settings. We noticed that that calculated field value is null in target beforeRecord={} dataset but does the expected calculation in record={} dataset. Is this expected behaviour. Is there anyway to force it to calculate in beforeRecord too.

Hi,

My requirement is for a dashboard to run on 1st and 2nd Friday each month. Below is how I had it setup. 

Custom increment: 0 0 1 0

Custom filter: * * 1,2 5 * * * *

After I created the task, noticed next execution field is blank and doubted if it would run. As expected, when I checked today (5/3 - first Friday) it did not. Where did I go wrong?

Appreciate any suggestions. Thanks!

Hi everybody,
I have an excel made in this way:

the note refer to question "Is the shop in city center?"; note1 refer to "Shop Size", and note2 refer to "Are there enough sale item".
I want to obtain a table like that:

Is possible to obtain it without using ALIAS? Maybe using the cell of excel like "A";"B";"C"....

Thank you so much
BYE 🙂

Hi I am trying to export the project using Compose CLI and I am getting below error. 

Command ComposeCliexport_csv failed SYS-E-HTTPFAIL, Session expired. 

This is what I am trying

<path where we have installed the compose software>\ComposeCli.exe export_csv --project <project name> --outfolder C:\EXPORT\ABC

Any help on this topic is greatly appreciated.

I have an AG with 3 nodes and 3 different subnets which means the listener has 3 ip's. Per Qlik instructions, you have to specify an ip when connecting to the listener. Since we have 3 ip's, how do we handle a failover to one of the other nodes if we are only specifying one ip in the endpoint connection?

I followed instructions detailed here

https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/work_with_sql_server_alwayson_availability_groups.htm

Hi, All,

Our NPrinting DEV server (May 2023 IR) has been running well for months. But yesterday I noticed its engine status is offline. Meanwhile, a task hangs (with 'Running' status) there forever.

So far I have checked/done the following but they do not help:
. All NPrintng services are running.
. I have rebooted the server a couple of times.

I found this error in engine.log and scheduler.log: RabbitMq service is not connected - trying again in 60 seconds. ERROR: RabbitMQ.Client.Exceptions.BrokerUnreachableException: None of the specified endpoints were reachable

I followed the instruction in this link (https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm) and executed ''rabbitmqctl.bat status' command, it gave me error saying I need to run 'rabbitmqctl start_app' command first. So I ran that 'rabbitmqctl start_app' command. It only displayed a message 'Starting node xxxxx...' and then returned. But the problem remains.

I have submitted Qlik support ticket. Just want to seek advice from the community while I am waiting.

Thanks

Hi,

I need to somehow get the difference between two dates assigned to variables and assign it in a new variable, what am I missing?

QFlag:
LOAD
EmptyColumn,
DateColumn
FROM [lib://QVDFilePath/QFlag.qvd]
(qvd);

LET vData=Peek('DateColumn', 0, Timestamp(QFlag,'YYYY/MM/DD hh:mm/ss'));
LET DateNow = Timestamp(Now(),'YYYY/MM/DD hh:mm/ss');
Let vMinus = Interval(($vData- $DateNow ), 'mm');

Drop Tables QFlag;

Trace '$(vData)';
Trace '$(DateNow)';

Results: 

Thank you.