Hello support team.

[Info]
Source DB : Db2 for iSeries

[Question]
About following limitation,
>Tables created by DDS: If you need to replicate tables created by DDS, please seek guidance from Qlik Support or your Qlik Customer Success Manager.
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedReplicateHDD/IBM4DB2-iseries/iseries_limitations.htm

Are tables created by DDS enable to be replicated ?
If yes, would you tell me how to replicate these table?

Best Regards.

Column CreatorDoc is missing from XML view of QVD in Qlik Sense February 2024.

After upgrading to February 2024 Patch 3 from May 2023 Patch 6. 
We have a small issue with the upgrade, this would hinder our ability to effectively troubleshoot some of the issues:
 
In some scenarios we would need to know the name of the app that creates QVD's as we have many extract and transform app, In the previous version we had a column "CreatorDoc" under XML view of QVD, this column stores the app id of the app that created QVD. This is no longer available in the new version. Is there any workaround or options?

Hello, 

We update our Qlikview from 12.10 to 12.20 but our apps don´t work, all our tables are loading but if we refresh the browser the table loads the info.

We tried to load the app using the new version but it didn´t work.

Somebody could help me with this?

Regards.

Hi,

We've noticed that Replicate reads from the same archived redo log file every couple  minutes. Does anyone know if this is normal behaviour by Replicate? The task does have high latency.

I did some other searches in task logs that don't have latency and found that they had multiple reads on the online redo logs on different dates and times.

So basically I just want to know if this is normal behaviour, and get a general idea of what is going on. It would be greatly appreciated. Thank you.

Regards,

Mohammed

Hi all, I'm trying to build a word report with a table to meet clients very specific asks around appearance, printing to PDF, etc. I have everything worked out mostly except an indicator and date coloring issues. I've tried color by expression, CSS, formula in Designer and I get some results but not others. I can get the object with color but it isn't aligned properly and the column width expands and there is no border. I have to keep the source formats for the color coding as it is based on a date comparison and as far as I can tell I cannot do that in Word without VBA. If i try to bring over the dates with color i just get a black cell. Any ideas beside using Excel?

Note: it is a Vizlib straight table, the character is chr(11044)

I have a stacked bar chart that shows sales by product by month. The first data label will be % of sales by product, this is easy to do. Is there a way to add a second data label with the expression to calculate average price using the formula of sales/item?

Olá.

Estou tentando descobrir como fazer para todos os dias na aplicação trazer apenas os dados do dia atual.

Tenha um campo data_lib_venda e queria que ele trouxesse apenas os registros do dia.

Alguém pode me ajudar? Obrigado a todos.

Hello everyone,

I need to extract a  BW cube by the qlik sap connector, but when I try to load the data ,it doesn’t work. The possible issue is that the connector can’t load in the same time 150 fields and more than 2 million of rows, indeed if I try to load only 20 fields the connector works correctly. Unfortunately to catch all cube dimensions I can’t split the load in “little sub load”. How can I do to apply a full load??

thanks a lot

Hi,

We use the REST Connector to load the data. Qlik recognizes and organizes the data from the API response: it creates multiple tables and adds a __KEY_root column to each table. That field (__KEY_root) is used for relations between those tables. 

So, __KEY_root is not from the API response, but it is the primary key that Qlik added to create relationships between the tables it generated based on the API response.

For example:

RestConnectorMasterTable:
SQL SELECT 
"id",
"name",
"__KEY_root",
(SELECT 
"@Value",
"__FK_domains"
FROM "domains" FK "__FK_domains" ArrayValueAlias "@Value"),
(SELECT 
"__FK_custom_fields"
FROM "custom_fields" FK "__FK_custom_fields")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(Url "https://*******/api/v2/***");

[domains]:
LOAD [@Value],
[__FK_domains] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_domains]);


[custom_fields]:
LOAD [__FK_custom_fields] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_custom_fields]);


[root]:
LOAD 
[id],
[name],
[__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);


DROP TABLE RestConnectorMasterTable;

Is it possible not to add __KEY_root but instead to use id (which is already unique)? We ask this because later we have to load the data using the API and update all those tables, it's a complicated and long story 🙂

We tried this (we removed/replaced __KEY_root with id😞

RestConnectorMasterTable:
SQL SELECT 
"id",
"name",
(SELECT 
"@Value",
"__FK_domains"
FROM "domains" FK "__FK_domains" ArrayValueAlias "@Value"),
(SELECT 
"__FK_custom_fields"
FROM "custom_fields" FK "__FK_custom_fields")
FROM JSON (wrap on) "root" PK "id"
WITH CONNECTION(Url "https://****/api/v2/****");

[domains]:
LOAD [@Value],
[__FK_domains] AS [id]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_domains]);


[custom_fields]:
LOAD [__FK_custom_fields] AS [id]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_custom_fields]);


[root]:
LOAD 
[id],
[name]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([id]);


DROP TABLE RestConnectorMasterTable;

But something is wrong, in these two "non root" tables the "id" column values ​​are still the values ​​generated by Qlik, starting from 1... (they are not actually the real "id" values ​​from the API response):