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

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?

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):

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.

I'm Akash Dhandhi( LinkedIn ), a skilled Qlik Analyst/Developer with 1.8 years of experience completely in Qlik Sense and Nprinting.I'm proficient in crafting insightful dashboards and reports.
and I also have a basic understanding of SQL and Python.

I'm actively seeking new opportunities, either in India or remotely. Please find my resume attached and feel free to reach out via [ Linkedin or Mail ] if you have any suitable openings.

Thank you for considering my application.

Hi, all!

Poll failed to create ... Please write your opinion..

It related to the topic, where more than two years ago hic replied Re: Sum() in the script using only one cpu core.

Let's see whether the QV community wants multithreading in the grouping in the script.

Of course, you can find a other way through the database, but this is not always convenient.

For example, we use the terminal server. And user dynamically generates a query.

Already built QVD data storage.

I can convert all such query and give user rights. Well, not really what we would not like to see this useful opportunity to QV?

P.S. I also want to add. Speed reading optimized QVD and place that takes QVD over SQL less at times it is for us the underlying factors to the vault in the QVD.

But such sadness that not multithreaded GROUP. Let us are working to make multithreaded.

Hello everyone!

I just published a new video showing how to work with normal distributions in Qlik. Check this out!

https://www.datavoyagers.net/post/how-to-create-a-normal-distribution-in-qlik

I have ~100 tables that I will use to do data ingestion to a data warehouse. We have a transformation mapping for some of the columns for each table, something like:
table_1
   - encrypt(column_X)
table_2
   - encrypt(column_X)
   - encrypt(column_Y)
table_3
   - encrypt(column_Z)

Is there any way to automate this? My first try was to create a task that would get data from all the tables and their columns, export the task, and update the exported JSON file on the manipulations part.
But when I tried to import the updated JSON, it failed. I assumed that this probably not that simple so wondering if there is some kind of "official" way to do this.