topic Re: Qlikview Transform Rows to Columns in QlikView

Qlikview Transform Rows to Columns

Anonymous — Tue, 16 Oct 2018 08:04:07 GMT

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 — Tue, 16 Oct 2018 15:53:53 GMT

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 — Tue, 16 Oct 2018 16:14:56 GMT