topic Re: Transforming an Excel table in QlikView

Transforming an Excel table

Tue, 31 May 2011 16:05:33 GMT

I have the next Excel tabel and i want to transform it into another format.

Source;

The table in QV should look like this.

Can anyone help me out here, I 've tried (see the attached QV file) but I didn't get to the right result.

Thnx in advance!!

pat_agen — Tue, 31 May 2011 16:36:35 GMT

hi,

not sure if you just wantthe result in a chart or if you are looking for an actaul table with three Facts A, B and C.

The attached qvw shows how to achieve both.

the chart solution can be built straight out of what you already have.

The table solution requires some more code in the script.

Tue, 31 May 2011 18:47:48 GMT

I'm looking for a actual table with the three facts, the example you sent me is almost the solution;

But I want the facts on one row so I can perform calculations on row level and not only on aggregated level.

pat_agen — Tue, 31 May 2011 19:19:09 GMT

add this code to the load script:

finalTable2:

load

'new' as dummy,

fProduct,

fDate,

sum(FactA) as FactA,

sum(FactB) as FactB,

sum(FactC) as FactC

resident finalTable

group by fProduct,

fDate;

drop table finalTable;

drop field dummy;

Tue, 31 May 2011 19:28:13 GMT

That's it!! Thnx!!