Qlikview Transform Rows to Columns

[Anonymous]

Hi all,

i have table in qlikview like this:

and i need to convert rows in column. In this example i need to transform Year in columns and Values in rows, to get table like this.

any idea?

[vishsaggi]

Use pivot table and add Limit , Person and Year as dimensions

expr as Sum(Values)

Then drag your Year field to top of your expr.

[nsetty]

The Generic Load