data modelling

[JoseGarcia]

Hi, 

I need to load excel file attached into QLIK.
The issue I have is that every month is listed as a header, therefore I cannot use the values within those cells to produce calculations & measures. 

Could anyone suggest a way to load this table into QLIK? 

I thought if there was a way to cross load a section of the table?

Thanks for the support.

Jose

[marcus_sommer · Accepted solution]

You need a transforming with The Crosstable Load - Qlik Community - 1468083

- Marcus

[JoseGarcia]

marcus, 

will the crosstable cells respect the relation with the rest of cells?

Regards

[marcus_sommer]

Yes, it will. All values from the normal fields are repeated in the rows when the columns are transposed into the rows. You may also check this by adding recno() and rowno() to the load.

- Marcus

[JoseGarcia]

marcus, it has taken me a bit of time & understanding, but managed to load data with crosstable function.

Thanks a million for your support!