Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table

Pivot Table

hello,

I have next pivot table

Transports

Weeknr     Car    Bus   Bicycle

52           100      75        6

51           44        33        2

50           22        11        4

49          11             3      1

48

47

etc

But now i want the years at the top so i can difference them.

How do i get the Year above?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Add the Year field as a Dimension. Then left-mouse drag the "Year" column heading to the upper right corner of the Pivot Table -- until the blue line turns horizontal -- and drop it there.

-Rob

View solution in original post

6 Replies
swarup_malli
Specialist
Specialist

Do you have a year field? in the app

Not applicable
Author

yes

Not applicable
Author

but when i select i get year field left

Not applicable
Author

and not on top

swarup_malli
Specialist
Specialist

I get not get you..when you say..

but when i select i get year field left

Could you attach a sample qvw file  in this thread ?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Add the Year field as a Dimension. Then left-mouse drag the "Year" column heading to the upper right corner of the Pivot Table -- until the blue line turns horizontal -- and drop it there.

-Rob