Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: Pivot Table

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

6 Replies
swarup_malli
Valued Contributor

Re: Pivot Table

Do you have a year field? in the app

Not applicable

Re: Pivot Table

yes

Not applicable

Re: Pivot Table

but when i select i get year field left

Not applicable

Re: Pivot Table

and not on top

swarup_malli
Valued Contributor

Re: Pivot Table

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 ?

Re: Pivot Table

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