Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would like to report what I believe is a bug in inner and outer set expressions feature (May 2023 patch 1), not sure if this forum can be a suitable location.
Given the the script,
Fruits:
LOAD * Inline [
Type,Color,Quantity
apple,green,1
apple,green,1
apple,green,1
orange,orange,1
orange,orange,1
];
Consider the below formulae outputs, where we select apples (which exist in the data set) and kiwis (which do not exist):
Sum({<Type={'apple'}, Color={'green'}>} Quantity) |
3 | OK |
{<Type={'apple'}>} Sum({<Color={'green'}>} Quantity) |
3 | OK |
{<Type={'apple'}, Color={'green'}>} Sum(Quantity) |
3 | OK |
Sum({<Type={'kiwi'}, Color={'green'}>} Quantity) |
0 | OK |
{<Type={'kiwi'}>} Sum( {<Color={'green'}>} Quantity) |
3 | WRONG!! The outer set analysis is not inherited! |
{<Type={'kiwi'}, Color={'green'}>} Sum(Quantity) |
0 |
OK |
Sum({<Type={'orange'}, Color={'green'}>} Quantity) |
0 |
OK |
{<Type={'orange'}>} Sum( {<Color={'green'}>} Quantity) |
0 |
OK |
{<Type={'orange'}, Color={'green'}>} Sum(Quantity) |
0 |
OK |
Sum({<Type={'kiwi'}>} Quantity) |
0 |
OK |
{<Type={'kiwi'}>} Sum( Quantity) |
0 |
OK |
As per the results above: outer set expression is not inherited if
Could someone confirm this is indeed a bug and whether it has already been fixed in the recent version? Thanks!
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
I'm working on creating a command to silently upgrade PostgreSQL using Qlik PostgreSQL Installer. One of the arguments that are mentioned in Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation is iprange
.
Does anyone know IP addresses of which devices in a network should be populated for iprange
argument?
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:
# | QPI Tool Argument | QPI Config File Attribute | Available in Both |
1 | acceptQCA | N/A | No |
2 | iprange | IpRange | Yes |
3 | maxconnections | MaxConnections | Yes |
4 | dbinstallationpath | DbInstallationPath | Yes |
5 | dbdatapath | DbDataPath | Yes |
6 | dbbackuppath | DbBackupPath | Yes |
7 | listenaddresses | ListenAddresses | Yes |
8 | dbusername | DbUserName | Yes |
9 | dbuserpassword | DbUserPassword | Yes |
10 | dbsuperuserpassword | DbSuperUserPassword | Yes |
11 | dbhost | DbHost | Yes |
12 | dbport | DbPort | Yes |
13 | qpiconfig | N/A | No |
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.
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
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!