Loading Complex Cross Table

[#1]

Hi QlikView Community,

I have a problem with loading a more complex cross table into my QlikView application. Maybe someone of you already had the same problem and can help me out. I have attached an example Excel file so that you know what I'm talking about.

Cheers,

Nam

[#2]

What do you need?

[#3]

I need to load all the fields.

[Gysbert_Wassenaar · Accepted solution]

See attached files for a solution that can handle multiple levels of horizontal and vertical dimensions.

[agni_gold]

what if , if i dont know about excel colum sequence ?