QGIS composer add attribute table with repeating columns

Question

I need some help with QGIS print composer. I use the atlas composer and I try to use add attribute table from layout tab.

I have create my expression where I want to print in composer.

field expression (that I want):

case when "myfield" is not null   then concat(myfield,' ',myfield1,' & ',myfield2) else concat(myfield1,' ',myfield3)

I have defined filter from item properties where I want to print with atlas:

intersects(buffer($geometry),50),$atlasgeometry)

but that shows like this:

value1
value2
value3
value4
value5
value6
value7
value8
value9

because of to many values I can't print them all in my layout. I need a result like this:

value 1   value2
value 3   value4
value 5   value6
value 7   value8
value9

If the values are like this then I can print all. If I want to add a legend then have option where you can choose columns

That is what I need for my attributes but I can't find something like this.

Finally I try to create a new expression with my field and I try to add next feature but without success.

I tried this:

dbvaluebyid('test','f_field', @row_number ) ||'' ||dbvaluebyid('test','f_field', @row_number +1)

but from this expressions I don't take next feature.

and this:

case when "myfield" is not null   then concat(myfield,' ',myfield1,' & ',myfield2) else concat(myfield1,' ',myfield3)  end ||  '                                    ' || case when "myfield" is not null   then concat(myfield,' ',myfield1,' & ',myfield2) else concat(myfield1,' ',myfield3)

any idea?

Answer 1

I found a way, but it's not really interactive for the moment. However, it allows some nice tweaks to have a pretty table displayed :

In QGIS

• Export your table in Excel

In Excel or similar

(Maybe this part could be automated in Excel)

• Filter the data if needed to have the table of your desire

• Create a new set of column after the first ones

• Cut and paste the extra records to the right of the first ones

• Get some style to your table

In Word or similar

• Copy and paste your new table into a word document (check the display)

• Save as an html document if it's ok

Text Editor

• Open the html file in a text editor (for example : Notepad ++)

• Copy the HTML code

Back in QGIS

• Create an HTML frame in your QGIS composer and paste the HTML code

Now you have your data in 2 columns.. with style :)