Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Anonymous
Not applicable

Cross Table with 3 dimension

Hi to all!!!! As always looking for a good soul!!!!

On the first image an excel table that I need to change using a cross table function and get the result that you will find in the second image.

I tried with normal cross table with no results...  I also tied spliting the tables (Table 1 Inventories, table 2 Transit units, ect...), use a cross table for each table  and use a left join or a concatenate creating a huge data mess...

Excel File with original data

Tabla Inicial.png

Expected result:

Resultado.png

On the next lines the script use:

cau:

CrossTable(Sku,SkuName,4)

LOAD
"Código de representante",
Localidad,
"Digitar el PLU # 1",
"Nombre del producto # 1",
"Inventario disponible producuto # 1",
"Unidades por llegar producto # 1",
"Fecha de llegada del producto (DD/MM/AAAA) producto # 1",
"Digitar el PLU # 2",
"Nombre del producto # 2",
"Inventario disponible producto # 2",
"Unidades por llegar producto # 2",
"Fecha de llegada del producto (DD/MM/AAAA) producto # 2",
"Digitar el PLU # 3",
"Nombre del producto # 3",
"Inventario disponible producto # 3",
"Unidades por llegar producto # 3",
"Fecha de llegada del producto (DD/MM/AAAA) producto # 3"
FROM [lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/Emergencia/XXXXXX]
(ooxml, embedded labels, table is Sheet1);

 

1 Reply
Highlighted
Employee
Employee