Sorting attribute table by hidden column in QGIS Print Composer

Question

In a QGIS 2.18.20 attribute table I have some values with random numbers, but at the print composer I want to show them with order (clockwise). So I made a new integer column, and added numbers with the way of sorting I want to appear at the print composer.

Now I can't find a way to hide the column I used for sorting the numbers. I need to use it to sort the columns, but when I delete it or do something similar the order disappears. Is there a way to keep the sorting the way I want, but to hide the sorting column? Can I do it with a different way? In the picture, "field 1" is the point number, field2&3 are the coordinates and ORDER is the sorting column

Ok I hid it with a white rectangle. If you know something more professional, feel free to answer! — Pitheas, Jun 01 '18 at 19:07
Can you copy and paste the formatted data from Excel/LibreSheet? We did that a lot with ArcMap but it commonly lost some formatting. Sometimes we got by with screen snippets of the Excel table or table pasted into the GIS map. The best looking results were done by creating pdf stamps of the table and adding them to an exported pdf map. — John, Jul 17 '18 at 13:29
I don't want to involve spreadsheet, the plan is to make the values shorted by the "ORDER" column but that column to be hidden from display. — Pitheas, Aug 22 '18 at 16:06
A feature request for this functionality was made on the 8 Jan 2019 and is still open. — Joseph, Oct 21 '19 at 09:45
Please, do not forget about "What should I do when someone answers my question?" — Taras, Dec 20 '22 at 14:38

score 14 · Answer 1 · edited Dec 20 '22 at 14:40

I suggest to use a Virtual layer through Layer > Add Layer > Add/Edit Virtual Layer.

If the SQL in virtual layers would give the same result than SQL that is fired directly against databases then the following should work

select a.field_1, a.field_2, a.field_3
from (
    select field_1, field_2, field_3, "ORDER"
    order by "ORDER"
    ) as a;

The result seems to work correctly in the print composer with QGIS 3.8.3. I wasted some time by trying to check the result by opening the attribute table of the new virtual layer in the map window with Open Attribute Table but it does not show the records like they are sorted with ORDER BY. Records are perhaps sorted also spatially. Fortunately in the print composer the order was logical and right.

My query from Create a Virtual Layer

Original table and sorted virtual table in Print Composer

score 8 · Accepted Answer · edited Oct 21 '19 at 16:59

8

You could do this in a different way by sorting the layer before using the composer. So:

Sort your layer with MMQGIS (plugin) by "ORDER" --> ascending.
Show this new table in composer and remove the field.

Here so screen shots: Here is the data:

Sort:

Check the differences:

Plot the sorted table without that field:

edited Oct 21 '19 at 16:59

Fran Raga

7,838
3
26
47

answered Oct 21 '19 at 16:57

César Arquero Cabral

3,439
1
16
53

Gabriel · Answer 3 · 2018-08-22T17:05:49.580

1

I don't have 2.18 installed anymore, but I remember doing this for a project last year:

in the map composer, go to the table's item properties
in the main properties tab, click on Attributes

From there you can manipulate your columns (change field order or even hide a field from output) and choose how to sort field values (ascending or descending).

edit: Both actions (sorting from field and hiding field) can't be used concurrently. If field is hidden, it cannot be chosen as a sorting rule.

edited Aug 22 '18 at 17:05

answered Aug 20 '18 at 14:35

Gabriel

3,136
13
33

That is the problem, when I short them,following the ORDER column, that column is no needed anymore for displaying in the composer. – Pitheas Aug 22 '18 at 16:08
After checking it out, I see what you mean. This could be a feature request for a future version, the ability to use a field from the table item for sorting while being able to hide it in composer. – Gabriel Aug 22 '18 at 17:03

Sorting attribute table by hidden column in QGIS Print Composer

3 Answers3

Linked