topic Straight or Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186121#M50354 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am unable to move the year horizontally. It always go vertical. Do I have to enable something to move a dimension horizontally.</P><P>If I am able to move, my problem is solved.</P></BODY></HTML> Tue, 15 Sep 2009 02:03:09 GMT 2009-09-15T02:03:09Z Straight or Pivot Table https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186119#M50352 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a requirement to use either straight table or the pivot table, to get what is there in the excel sheet. If you see the the excel sheet, Country, Type (Base, OSD, Total) and the year (2008, 2009) are the dimensions. I have used a straight table to get this, but unable to get dimension Year horizontally and also type (Base, OSD, Total) totals horizontally. Is there any way of doing it. See the attachment.</P><P>--San</P></BODY></HTML> Mon, 14 Sep 2009 21:24:10 GMT https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186119#M50352 2009-09-14T21:24:10Z Straight or Pivot Table https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186120#M50353 <HTML><HEAD></HEAD><BODY><P>For a Pivot Table - Add year as a dimension and drag and drop the Year dimension above the Quarter. For subtotals go to the presentation tabl and select the field that you want to subtotal</P></BODY></HTML> Mon, 14 Sep 2009 22:26:59 GMT https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186120#M50353 2009-09-14T22:26:59Z Straight or Pivot Table https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186121#M50354 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am unable to move the year horizontally. It always go vertical. Do I have to enable something to move a dimension horizontally.</P><P>If I am able to move, my problem is solved.</P></BODY></HTML> Tue, 15 Sep 2009 02:03:09 GMT https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186121#M50354 2009-09-15T02:03:09Z Straight or Pivot Table https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186122#M50355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>just give it a try and drag the title in a slow bow first down, then to left and slighty upwards. Should work then.</P><P>HTH<BR />Peter</P></BODY></HTML> Tue, 15 Sep 2009 02:28:52 GMT https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186122#M50355 prieper 2009-09-15T02:28:52Z Straight or Pivot Table https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186123#M50356 <HTML><HEAD></HEAD><BODY><P>Yes it worked. Thanks.</P></BODY></HTML> Tue, 15 Sep 2009 21:05:00 GMT https://community.qlik.com/t5/QlikView/Straight-or-Pivot-Table/m-p/186123#M50356 2009-09-15T21:05:00Z