topic Re: How can I turn the values of a column into header of other columns? in QlikView

How can I turn the values of a column into header of other columns?

mlarruda — Fri, 06 Apr 2018 21:12:13 GMT

I have one table like this:

And I want to turn it into a table like this:

Name	2016	2017	2018
Adam	1	2	3
Ben	4	5	6
Carl	7	8	9

How can I do it?

Many thanks in advance.

vishsaggi — Fri, 06 Apr 2018 21:20:29 GMT

use generic load like below

GenericTab:
Generic Load Name, Year, Value
FROM
[https://community.qlik.com/thread/297410]
(html, codepage is 1252, embedded labels, table is @1);

mlarruda — Fri, 06 Apr 2018 21:25:00 GMT

Does it works, being Value the result of an expression, rather than a "pure" variable?

vishsaggi — Fri, 06 Apr 2018 21:35:03 GMT

Why don't you simply use a pivot table. Like

add

Dimensions: Name, Year

Expr: Sum(Value)

Then drag your Year field to top of Expr.

mlarruda — Fri, 06 Apr 2018 21:37:15 GMT

Sorry for my ignorance, but how I build/define a pivot table?

mlarruda — Fri, 06 Apr 2018 21:48:33 GMT

Done! Thanks!

vishsaggi — Fri, 06 Apr 2018 21:48:41 GMT

Load your data as is. Like

LOAD Year, Name, Value

From yourtablename;

Then right click on sheet properties and select Chart.

Then use Pivot table like below

Then in the dimensions tab you can see your fields

Then add Name and Year to your dimensions and in the expression tab

Add your expression like Sum(Value).

After that you have to drag your Year field to the top of expression.

When you drag you can see a blue arrow like in the above screen shot. Just drag and drop on top of Exper Sum(Value)

vishsaggi — Fri, 06 Apr 2018 21:49:20 GMT

Awesome. Cool.