Hello 

i have a task setup from source (Microsoft SQL server) to target (Microsoft SQL server). there are three tables of which two are transactional data and i have noticed that for one of the tables, updates are not captured. Inserts and deletes are the only change processing that the LSS captures for one of the tables. This has led to discrepancies when queries are run and comparedon both the source DB and the target DB as the updates made on the source DB are not captured on the LSS task. 

A column in the table on the source DB may have 0 as the value but later it gets updated to a 1, this action/change doesnt get effected on the target DB so that particular records remains 0 on the target DB.

Has any encountered this challenge before 

I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is what I've written, but it isn't correct. What am I doing wrong?

Sum({<Date#([Projected Close Date])>={Date#(Today())+370}>}Combined_Amount)

Hello to all

I have a list of cusomer with quantity, date, region, sub region and Sales responsible. I woul like to do a pivot table  with region, sub region and Sales reps in row and column of month. The data to be displayed are the sum of quantities realized in 2023 for the customer that did not had any sales during the last to years (Q= 0)

i have tried the follong formula bu it does not work at all

=if(aggr(sum({< YEAR= {"<=$(Vannee-1)"},NO_CUST=,MONTH=>}Q),NO_CUST<=0,
sum({< YEAR= {"$(Vannee)"}, NO_CUST=, MONTH=>}
Q),0)

I have added in excel cause it shows in the pivot what i want.

Thanks in advance....

Hi Team,

I am facing issues while loading full loading file with Qlik Replicate. I have explained the issue in given steps below:

Full File load every time >> Frequency will be for every one hour  >> Need to process latest files for every one hour

In my requirement, we used to receive the files from vendor with full set of files for every one hour, in that case they used to keep on appending the files in same location for every one hour, so Qlik replicate either to identify the latest files & to process them, or i do need to archiving the files manually after processing through Qlik Replicate every one hour which is again tricky since we don't predict when files arrives at source.

I am facing issue in identifying the options for full load with given options in Qlik Replicate, hoping can someone from Qlik support could help me on this.

Thanks in advance!!!

Hello, we have some tasks that read delimited text files as sources and put them into MS SQL target.

Is there a way to move the files to a different location(Folder) after they have been processed successfully?

E.g. The files are dropped in F:\Share\Source and then after processing must be moved to F:\Share\Processed

I have tried to set the values that I found on the Endpoint Connection itself, Under Change Processing Cleanup, but this doesn't seem to want to work for me. Nothing happens.

We are using: Qlik Replicate May 2021 (2021.5.0.1272), running on Windows Server 2019 in Azure

Qlik Replicate 

I have an application in the name like as "application  1"

but when i search like  "  " the application "application  1" is not picked up. 

why just space is allowing to pickup the application that has a space.  

even in the root admin column of qmc application, I am unable to sort by blank values? is there a way to accomplish this .