Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

how to load this table into qlikview?

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   

3 Replies
Highlighted
Creator II
Creator II

Re: how to load this table into qlikview?

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,

Highlighted

Re: how to load this table into qlikview?

Hi,

Check the below link.

multi_header_pivot_import.qvw

Highlighted
Employee
Employee

Re: how to load this table into qlikview?

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