2

I have difficulty in how to rotating attribute table in QGIS Composer. The default is horizontal, it's because data I have too much around 50 tables. So I want to rotated it to horizontal.

Under the map, or maybe there is another way for me to include this all record and print it out?

enter image description here

5

There is no direct way to rotate/transpose your attribute table in the map composer as far as I know. A workaround to this is:

  1. Right-click the file and go to save as, then Save your attribute table as CSV. If you don't want to add XY coordinates as additional columns to the CSV file, select Default in GEOMETRY under Layer options.

enter image description here

enter image description here

  1. Open the CSV file in Excel
  2. Then copy the columns
  3. Paste them in another sheet with using paste special, and select Transpose
  4. Save it again as CSV file

Then drag and drop the new CSV file into QGIS. In the composer add the transposed attribute at the bottom of your map.

enter image description here

  • Sorry I dont know how to save attribute table as CSV ???? i am very new with this, please and thank you – Endy Hidayat Feb 6 '17 at 4:17
  • I updated I my answer to show you how to save the file as CSV. – ahmadhanb Feb 6 '17 at 4:58
1

@ahmadhanb's answer is a good workaround but here is another way to deal with long tables.

Although there is no way to transpose a table in the composer, you can split your table into multiple frames. Now depending on the case, this could be more or less elegant, but this is how the result looks like:

Split table

Here's how to do it:

  1. Add a table as you would normally do and select its source layer.
  2. Scroll down the properties till you get to Frames. table properties
  3. Click Add Frame.
  4. Align and resize your frames as may be suitable to your map layout.
  5. It is also a good idea to turn on Show only features visible within a map. This way you won't have a table with all the layer features on your map!

show visible

P.S. It is possible to rotate the table, but unfortunately, the text also rotates and you end up with vertical text, which doesn't look very elegant. enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.