The Stack Overflow podcast is back! Listen to an interview with our new CEO.
7

I suggest to use a 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 ...


3

You can retrieve the extent coordintes of map item via variables, and use them in text box. x_min - [% to_dms(x_min(transform( map_get(item_variables('map'),'map_extent'),'EPSG:3857','EPSG:4326')),'x',2)%] y_max - [% to_dms(y_max(transform( map_get(item_variables('map'),'map_extent'),'EPSG:3857','EPSG:4326')),'y',2)%] Expression explained step by step: To ...


1

When you export a layout as a PDF, QGIS can either export all the content as a raster (i.e. an image embedded in the PDF, so when you zoom in or save in low quality details and edges look pixelated), or some/all elements - typically text - as vectors (so that you can zoom in as much as needed without seeing quality degradation). It looks as if your PDF ...


1

If anyone is having this issue in QGIS 3, the settings are hidden (for now?)... Right-click the page Choose 'Page Size' The 'Item Properties' panel now contains your page size settings (it doesn't normally show them) This is a strange method to get to the page size, as I'm seeing issues even using the menu Layout > Page size on various operating systems to ...


1

Yes it is possible without plugins. You need to create two grids: one for the UTM Coordinates and the other for WGS84. Here is an image that shows both of the grids. The black grid is UTM and the red is WGS 84. For UTM, I think you know how to do it since the data is in UTM. Now, When adding additional grid for WGS 84, you need to change the CRS to WGS 84 ...


1

That sounds like a bug in the program. QGIS 2.18 is no longer supported, which means bugs are no longer being fixed. Update to a current version of QGIS and the issue will probably be resolved. If you must use 2.18 for some reason, at least update to the latest minor version. The latest minor version of 2.18 was 2.18.28 for both Windows and Mac OS.


1

For styling, you could try setting up a symbol under rule based symbology and do one of the following: Setup a rule with is_selected() IS TRUE / is_selected() IS FALSE, or Setup a virtual field (e.g. called Selected) with the expression is_selected(). Then set the symbol rule to "Selected" = 1 (if virtual field is an integer field), or "Selected" IS TRUE (...


Only top voted, non community-wiki answers of a minimum length are eligible