topic Re: Aggregate codes from Excel in QlikView

Aggregate codes from Excel

Thu, 18 Sep 2014 12:52:05 GMT

Hello everyone,

I need your help about a development problem.

I have an Excel that is regulary updated. It is composed of a supplier name, and several site.

Each supplier may be present for one or several sites, with a different code (I join you an Excel file for a better understand).

Do you know how can I aggregate all codes behind the supplier name, to automatically get back corresponding data from the several sites ?

I hope I am clear...

Thanks lot for your help

MarcoWedel — Thu, 18 Sep 2014 12:54:39 GMT

see Crosstable load in help file

MK_QSL — Thu, 18 Sep 2014 12:56:33 GMT

use cross table

DATA:

CrossTable(Site, Data)

LOAD Supplier,

[Site A],

[Site B],

[Site C],

[Site D]

FROM

[qlik-suppliers (1).xlsx]

(ooxml, embedded labels, table is Feuil1);