topic Re: how to load this table into qlikview? in QlikView

how to load this table into qlikview?

Frank_Hartmann — Tue, 08 Sep 2015 15:24:10 GMT

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

Re: how to load this table into qlikview?

Anonymous — Tue, 08 Sep 2015 17:02:10 GMT

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,

Re: how to load this table into qlikview?

settu_periasamy — Tue, 08 Sep 2015 17:28:41 GMT

Hi,

Check the below link.

multi_header_pivot_import.qvw

Re: how to load this table into qlikview?

JonnyPoole — Tue, 08 Sep 2015 17:33:49 GMT

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