Transposing data matrix in Excel to table in QlikView

[#1]

So I have an Excel spreadsheet that has a vertical dimension and horizontal dimension, with data values in the matrix cells. So it looks something like this:

              Quarter >>> Q1     Q2     Q3     Q4

Cost Type

vvvvvvvvvv              

OpEx                         $1M     $2M     $1M     $3M

CapEx                         $2M     $3M     $2M     $1M

How can I transform this table into something QlikView can use?

[luciancotea]

See CROSSTABLE in help.

[#3]

Hi. look this example.

[#4]

So what exactly did you do there? How did you get from your spreadsheet to the script?

[CELAMBARASAN]

Try with Cross Table

Might be like

Cross Table(Quarter, Cost)

Load

     CostType,

     Q1,

     Q2,

     Q3,

     Q4

FROM ExcelSource;

Hope it helps

[#6]

Sorry about my english....

First - Go to the Script and  the file in labels i set Embedded Labels, click on next

Second - Click on Enable Transformation Step

Third - Go to rotate Guide and click one time in the button "Right "

Reload the file