column to row

[#1]

Is there a way columns can be displayed as rows in qlikview?thanks.

current looks:

Emp	ID	Location	Role	Manager
Rose Smith	1	Austin	Admin	Lisa Johnson
Jon King	2	Richmond	Sys Engineer	Dean White

New look should be

EMP	Rose Smith	Jon King
ID	1	2
Location	Austin	Richmond
Role	Admin	Sys Engineer
Manager	Lisa Johnson	Dean White

[rustyfishbones]

Not that I know of, I would be interested to see if it can be done

I will investigate

[#3 · Accepted solution]

Hi Pooja X,

If the Chart is a straight table there is a Horizontal checkbox on the Presentation tab which will switch the columns to rows.

Kind Regards,

Footsie.

[kumarnatarajan]

Hi,

Find the attached file

[Sokkorn]

Hi Pooja x,

Keep your data source like above table.

Pooja x wrote:

Is there a way columns can be displayed as rows in qlikview?thanks.

current looks:

Emp	ID	Location	Role	Manager
Rose Smith	1	Austin	Admin	Lisa Johnson
Jon King	2	Richmond	Sys Engineer	Dean White

1. Create new Straight Table with 5 dimension: Emp, ID, Location, Role and Manager.

2. Goto Presentation ==> Uncheck <Suppress Zero-Value> and Check <Horizontal>

Regards,

Sokkorn

[#6]

Can you please let me know why need to uncheck 'supress zero values'.

[#7]

Guys..thanks for the response.Is there a way same can be achieved in table box and pie chart?

[Sokkorn]

Hi Pooja,

Because I don't use any Expression. Nothing to display, if you use only dimension in Straight Table and check supress zero value.

Regards,

Sokkorn