Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Crosstable with specific columns

All,

I have struggling been with this query for a while now.

I want to use a Crosstable load to import some excel data. My query is how does one load in data using the crosstable when the "qualifier fields" are in the middle of the dataset. See attached example:

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try this,

CrossTable(Column,Data,2)

Load C,

        E,

        A,

        B,

        D

From Xyz;

You need to remember that you must keep the columns which you need to qualify (Keep as it is) at top in load order.

Just like in your case it will be C and E on top and others at bottom.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try this,

CrossTable(Column,Data,2)

Load C,

        E,

        A,

        B,

        D

From Xyz;

You need to remember that you must keep the columns which you need to qualify (Keep as it is) at top in load order.

Just like in your case it will be C and E on top and others at bottom.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

if you can't change the initial load order, then you could use a crosstable resident load from your already loaded table:

table1:

LOAD A,B,C,D,E

From Somewhere;

table2:

CrossTable (Name, Value,2)

LOAD  C,E,A,B,D

Resident table1;

Drop Table table1;

hope this helps

regards

Marco

Highlighted
Contributor
Contributor

Great thanks mate