Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data as column (Table)

Hello!

Is possible, turn some years as Columns?

I tried, but it failed.

Thanks !

1 Solution

Accepted Solutions
Partner
Partner

Hello
got to chart properties > presentation and mark "horizontal"

View solution in original post

17 Replies
Specialist
Specialist

Load your table as Cross table

Not applicable

Create as a pivot table, then drag the dimension up as a column

Anonymous
Not applicable

I tried, but it stays like this.table.jpg

Anonymous
Not applicable

I tried, but it didnt work.

I think i need expression as dimension. Am i right?

MVP
MVP

What is the dimension and expression you are using?

Anonymous
Not applicable

Dimension i'm using 'Year'.

And expression, 2 var%.

You can see it in the image, in first topic.

Thanks !

MVP
MVP

what's wrong ? what you expect and what you getting?

Anonymous
Not applicable

I need to have the year 2011, 2012, 2013 and 2014 as column. And expressions as lines.

But it's not possible just using Cross Table and drag it to the right place.

MVP
MVP

Do something like  this.... don't know your exact column/Field name so giving suggestion using sample field..

Let we have Customer, Year and Sales as Field... You can use as below

Dimension

Customer

Expression

SUM({<Year = {'$(=Max(Year))'}>}Sales)

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-2)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-3)'}>}Sales)

Hope this helps...