Hello

we want to transfer data from db2 for z/os -> Postgres once a time with a FULL LOAD task for  a group of tables.

Is it possible to perform this without enabling CHANGE DATA CAPTURE on that group of tables ?

Thanks

AF

I really liked chart exploration in straight table chart recently added to Qlik sense. Can Qlik sense add this feature also to the official table chart?

Hi All, 

Recently, we encountered a situation where the CPU utilization on the consumer nodes within the Qlik Sense Enterprise production environment reached 100% Wherein the Repository.exe on the consumer node is taking all the CPU. As a consequence, the Qlik Sense Hub became either inaccessible or significantly slowed down for all end users

The current interim solution involves rebooting the consumer nodes daily in the morning. However, we are actively seeking a permanent resolution to this issue. If anyone has encountered a similar problem within the Qlik Sense Enterprise environment and found a solution, your insights would be greatly appreciated.

Config- We have QS Nov 2022 installed with Cloud SQL instance Postgres as Repository.

Hi, I'm really new to qlik and have tried to find most things on different forums but now I got stuck and was hopeing someone could help me.

How can I rearrange the columns on this table? I would need it to show the quarters on a chronological order.

Thanks in advance!

Dear all

We have successfully upgraded PostgreSQL with 14 version.

Everything running fine but only one thing I have noticed about the postgres service user running this service

 By default "Log On showing as" network service, is it normal ? or do we need to change its user as service account user running all other qliksense services?

Hello, 

A bit at a loss while trying to implement a specific set of actions on a button click. 

I have a table, i have some filters that can be applied. I have a button that selects just the ID after filters are selected and clear the rest of the filters. I want yet another button that does the opposite. It needs to exclude from the selected accounts from the previous selection. Using 'select exclusion' works, but for the whole table. The previous selection is overwritten. 

As in the picture attached, i want to use the filters to get a subset of the 7 ids already selected. Let's say number 1 and 3. The Exclude selection button should exclude 1 and 3 and lock the final selection to 2,4,5,6,7. At the moment it returns all IDs in the table(which ar emore than 7) except 1,3.

Any advice?

Thank you!

Hi,

we are facing this warning message when using the PATCH method in tRestClient:

WARNING: An illegal reflective access operation has occurred

WARNING: Illegal reflective access by org.apache.cxf.common.util.ReflectionUtil$11 (file:/C:/Program%20Files%20(x86)/Talend/studio/configuration/.m2/repository/org/apache/cxf/cxf-core/3.4.4/cxf-core-3.4.4.jar) to field sun.net.www.protocol.https.HttpsURLConnectionImpl.delegate

WARNING: Please consider reporting this to the maintainers of org.apache.cxf.common.util.ReflectionUtil$11

WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations

WARNING: All illegal access operations will be denied in a future release

We tried Open Studio and Studio Data Fabric with Zulu Version 11.

The patch is successfully executed but the warnings are still irritating.

With other methods (GET, POST, PUT) no warnings occure.

The design of the job is straight forward.

Any ideas?

Thanks

Ben

Hi,

I am looking to get different dimension values based on same ranking. So, I have created an inline view with Dim and Exp by assigning a value to each dim.

Load * Inline
[
dim, exp
'Style', '1'
'Colour', '2'
'Min Range of Month', '3'
'RRP', '4'

];

 And I am looking to bring the corresponding values thru if statement on Straight table

The below expression is not working as expected,

if(exp='1',only(if(Aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Style])),

if(exp='2', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Colour])),

if(exp='3', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Min Range Month])),
if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, Sum([Sales Amount]))
)
)
)

Can you please check my set analysis and advise why it's not working for other values. 

Thanks in advance.