Hi Team,

We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having trouble accessing the Qlik Replicate Console. Any assistance you can provide would be greatly appreciated.

Thanks!

Hi.

I have a timestamp field and I need to keep the time in the field but want to show it in a table with the 24 hour format (preferably without seconds)

The field is in the database as DD-MM-YY hh:mm:ss

In Data Manager I can show the date at DD/MM/YY HH:mm

In the load script (for some reason) the format shows as:

Timestamp(Timestamp#([occured_time], 'DD-MM-YYYY hh:mm:ss') ,'DD/MM/YYYY HH:mm') AS [occured_time],

In the Qlik Table it shows as a ?

What might I be doing wrong?

Very frustrating!!

Thanks 

Mark

Good day

We have an environment where we are using Qlik Sense client managed, Qlik Cloud and Qlik Data Gateway. We are creating reports on Qlik client managed (where we have a connection created to the SQL database). Once the apps are created we then distribute to Qlik Cloud where users view the apps. We are also hoping to then integrate our Qlik apps to our company website for clients.

Is this the most efficient way to develop the Qlik platform? Or does anyone have advise on how this could be improved?

Hi!

I have an issue with creating files on an FTP server using Qlik Automations. 

It is possible for me to list and read existing files from the FTP but when I try to create a file I get the error:
fopen(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

I thought first maybe that the credentials I am using don't have authorization to create or add files but when I'm trying it through WinSCP it works without any problems. 
I have talked to the person responsible for the FTP server and they tell me that it should not be any issue for the credentials I use. 

Do anyone know what the issue may be?

Thanks in advance,

Adam J.

Hello All, 
I have two variables in my Include file

LET vNumOfYears = 4;
LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD');

Currently I am taking last 4 years of data, but now I just want to show Current Quarter+ last 4 Quarters of data
I want to remove taht 4 in NumOfYears and add my new condition there (4 quarters before + current quarter )

I need to show that in above variables

Please help to get this

thanks!!

I made a measure for taking into account the efficiency of certain producers 

(
	Sum(
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)
/
(
	Count( 
    	distinct WorkingDay) 
        * 7.5 * 60)

And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do: 

(
	Sum( {<Employee=>}
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)

/

(
	Count( {<Employee=>}
    	distinct WorkingDay) 
        * 7.5 * 60)

But this doesn't work, and gives me null values. How could I fix this? 

Hi,

I want to change color of column headers. Like, background of "Mağaza Genel Yönetim Gideri" is blue and "Mağaza Pazarlama Satış Maliyeti" is red. How can i do that?

repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

command getcheckpoint response:

{

        "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

}

[getcheckpoint command] Succeeded

Regards

Dipankar

Hello,
Is it possible to do cell sorting by color in qlikView?

I have such data and I would like to sort in such a way that records must be colored first.

Please help!!!