topic Re: column to row in QlikView

column to row

Wed, 22 May 2013 20:50:01 GMT

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

Re: column to row

rustyfishbones — Wed, 22 May 2013 20:55:51 GMT

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

I will investigate

Re: column to row

Thu, 23 May 2013 06:57:11 GMT

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.

Re: column to row

kumarnatarajan — Thu, 23 May 2013 07:07:01 GMT

Hi,

Find the attached file

Re: column to row

Sokkorn — Thu, 23 May 2013 07:22:35 GMT

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

Re: column to row

Thu, 23 May 2013 17:28:37 GMT

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

Re: column to row

Thu, 23 May 2013 17:30:26 GMT

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

Re: column to row

Sokkorn — Fri, 24 May 2013 01:21:45 GMT

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