topic Re: Transposing data matrix in Excel to table in QlikView in QlikView

Transposing data matrix in Excel to table in QlikView

Thu, 12 Sep 2013 20:26:26 GMT

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?

Re: Transposing data matrix in Excel to table in QlikView

luciancotea — Thu, 12 Sep 2013 20:39:13 GMT

See CROSSTABLE in help.

Re: Transposing data matrix in Excel to table in QlikView

Thu, 12 Sep 2013 20:47:51 GMT

Hi. look this example.

Re: Transposing data matrix in Excel to table in QlikView

Thu, 12 Sep 2013 22:53:29 GMT

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

Re: Transposing data matrix in Excel to table in QlikView

CELAMBARASAN — Thu, 12 Sep 2013 22:54:09 GMT

Try with Cross Table

Might be like

Cross Table(Quarter, Cost)

Load

CostType,

Q1,

Q2,

Q3,

FROM ExcelSource;

Hope it helps

Re: Transposing data matrix in Excel to table in QlikView

Fri, 13 Sep 2013 12:39:35 GMT

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