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

I have a data model including two data sources (SAP & Salesforce) - please see the attachment. SECURITYKEY is in SAP table. After applying section access, some data rows from Salesforce table disappear. How can this be fixed?

Hello everyone,

I have two similar tables that I want to do a full outer join on to become one. I want to include all fields from both tables where there is a match and create a column that explains whether the row is on the left table, both tables or right table. I've looked this up both the other questions in the community don't work for me. Example data below.

Server Warehouse:

Database Warehouse:

Expected Outcome:

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

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)

{<Type={'apple'}>} Sum({<Color={'green'}>} Quantity)

{<Type={'apple'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'kiwi'}, Color={'green'}>} Quantity)

{<Type={'kiwi'}>} Sum( {<Color={'green'}>} Quantity)

{<Type={'kiwi'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'orange'}, Color={'green'}>} Quantity)

{<Type={'orange'}>} Sum( {<Color={'green'}>} Quantity)

{<Type={'orange'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'kiwi'}>} Quantity)

{<Type={'kiwi'}>} Sum( Quantity)

As per the results above: outer set expression is not inherited if

1. the outset set expression selects an inexistant value,
2. there is an inner set expression

Could someone confirm this is indeed a bug and whether it has already been fixed in the recent version? Thanks!

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?