how to load this table into qlikview?

[Frank_Hartmann]

Hi QV Community,

is it possible to load the attached table as a cross table into qv?

or in general:   

is it possible to load the table into qv without losing information?

thanks for helping   

[Anonymous]

Hi,

I think you can't use crosstable in this case.

I guess there are two solutions, you can change the spreadsheet and organize the data or you can load the spreadsheet in qlikview and try to organize, using qlikview functions.

Best Regards,

[settu_periasamy]

Hi,

Check the below link.

multi_header_pivot_import.qvw

[JonnyPoole]

The code for a table with 2 levels of row headers is not attractive and i would suggest reformulating the source file. A Crosstable can take care of 1 level of row headers easily, but 2 is ... not that attractive.

Also , you will need to populate the missing (empty) values for the first column as well the the row headers. The first column can easily be filled using a 'Fill' step in a transformation with the load wizard , but doing a fill on the missing row header values  as part of a crosstable is also a bit much in my honest opinion.  I just think you would end up with code that either isn't dynamic or its just looks complex and  only yourself will understand or a someone else well versed with the product which shouldn't (ideally) be the goal.

my 2 cents