topic Re: Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742415#M1260819 <HTML><HEAD></HEAD><BODY><P>Do you have a year field? in the app</P></BODY></HTML> Thu, 13 Nov 2014 21:37:50 GMT swarup_malli 2014-11-13T21:37:50Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742414#M1260816 <HTML><HEAD></HEAD><BODY><P>Pivot Table</P><P></P><P>hello,</P><P></P><P>I have next pivot table</P><P>Transports</P><P>Weeknr&nbsp;&nbsp;&nbsp;&nbsp; Car&nbsp;&nbsp;&nbsp; Bus&nbsp;&nbsp; Bicycle</P><P>52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4 </P><P>49&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>48</P><P>47</P><P></P><P>etc</P><P></P><P>But now i want the years at the top so i can difference them.</P><P>How do i get the Year above?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742414#M1260816 2026-01-26T18:19:17Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742415#M1260819 <HTML><HEAD></HEAD><BODY><P>Do you have a year field? in the app</P></BODY></HTML> Thu, 13 Nov 2014 21:37:50 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742415#M1260819 swarup_malli 2014-11-13T21:37:50Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742416#M1260822 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Thu, 13 Nov 2014 21:55:08 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742416#M1260822 2014-11-13T21:55:08Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742417#M1260825 <HTML><HEAD></HEAD><BODY><P>but when i select i get year field left</P></BODY></HTML> Thu, 13 Nov 2014 21:55:34 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742417#M1260825 2014-11-13T21:55:34Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742418#M1260827 <HTML><HEAD></HEAD><BODY><P>and not on top</P></BODY></HTML> Thu, 13 Nov 2014 21:55:44 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742418#M1260827 2014-11-13T21:55:44Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742419#M1260829 <HTML><HEAD></HEAD><BODY><P>I get not get you..when you say..</P><P></P><P><EM><STRONG>but when i select i get year field left</STRONG></EM></P><P></P><P></P><P>Could you attach a sample qvw file&nbsp; in this thread ?</P></BODY></HTML> Thu, 13 Nov 2014 21:58:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742419#M1260829 swarup_malli 2014-11-13T21:58:06Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742420#M1260831 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>-Rob</P></BODY></HTML> Thu, 13 Nov 2014 22:17:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/742420#M1260831 rwunderlich 2014-11-13T22:17:58Z