Hi There,I have n number of columns in the table and I would like to apply rank function on below variables based on latest survey date where i can filter out rank = 1.

Appreciate your advice.

Something similar to SQL Query.

rank() over (partition by COUNTRY, STATE order by survery_date desc)

from table

where rank = 1

Impact on SourceDB side when CDC using LogMiner is executed

I would like to check how much load CDC using LogMiner is putting on SourceDB.
Please tell us about the impact of LogMiner on the performance of Oracle (SourceDB) CPU/IO, etc.

Best regards,
Hironori Fujihira

The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in green, and Days3 in red. How do I write the color expression?

I'm working on creating a script file to silently unbundle and upgrade PostgreSQL database in my environment. The Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation mentions both a list of attributes that could be included in a command to silently unbundle and upgrade PostgreSQL database.

The arguments and attributes are largely the same. Here's the complete list of arguments and attributes:

11 out of 13 arguments/attributes exist in both. I'm assuming that means that those arguments/attributes can either be typed into Command Prompt manually or saved into a configuration file.

But they shouldn't be typed in both the command and config file.

Put differently, is it true that overlapping arguments and config file attributes must be provided either in a command or in config file but not in both places? Does anyone know?

After using AutoML to predict weather, I inputted the predicted results and actual temperature table into Qlik Sense. The two are connected by date. 

Formula of date for predicted weater:  

Date#('202303' & num([automl_row_index]+1,'00'), 'yyyymmdd'), 'yyyy/mm/dd')

Formula of date for actual weater:  

Date( Date#( Year & Num(Month(Date#(Month, 'MMM')),'00') & num(Day,'00') ,'yyyymmddd'), 'yyyy/mm/dd') 

Yet, the dates are sorted like this in the filter pane:

it is orderd by day instead of month and then day

due to find Qlik Sense Enterprise for Windows Remote Code Execution (RCE) Vulnerability (Authenticated). with suggestion we need to install patch 6 to solve this problem. 

After download the patch and run with administrator on server.  System show logs and installation failed.

detail see file attached. 

It is very urgent for me to find a solution.  Any one met same case and solved.

BS

jens

Hi Team,
We are facing an issue while configuring the Qlik replicate environment for High Availability (HA). We are trying installing Qlik Replicate Data folder in the shared storage as per the given article, after that the services are not getting up.

https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Clusters/install_replication_in_cluster.htm

Please connect for better clarity as the steps are not clear from the point of installation.