Hi Andreas, Last time I tried, virtual layers did not work as coverage layers. One would need to export the layer before using it.
Do you confirm this? Cheers, Alex Neto A ter, 26/03/2019, 13:21, Marco Antônio Ferreira Pedrosa < marcomot...@gmail.com> escreveu: > Hi Andreas, > > Thanks, it will be useful!! > > Best regards! > > > -- > > Marcão > > > skype: marco.afp > > > Em ter, 26 de mar de 2019 às 10:14, Andreas Neumann <a.neum...@carto.net> > escreveu: > >> Hi, >> >> It would be a join without a where clause, but limiting to the attribute >> columns that are relevant. See >> http://www.sqlitetutorial.net/sqlite-cross-join/ >> >> You would have to create a new virtual table in QGIS for it. See >> https://docs.qgis.org/3.4/en/docs/user_manual/managing_data_source/create_layers.html#creating-virtual-layers >> >> After creating that new virtual layer you can use it as Atlas coverage >> layer. >> >> Greetings, >> >> Andreas >> >> On 2019-03-26 13:56, Marco Antônio Ferreira Pedrosa wrote: >> >> Hi Andreas, >> >> How can I create and use a cross-join in this case? (I think it would be >> useful for the other tasks that I have to work on) >> >> Tnks in advance. >> >> -- >> >> Marcão >> >> Em ter, 26 de mar de 2019 às 09:46, Andreas Neumann <a.neum...@carto.net> >> escreveu: >> >>> Hi, >>> >>> Atlas with combinations of two or more attributes, and/or sometimes also >>> feature geometries - this is a typical case for a cross-join in a database. >>> You would create a new view as a cross-join with all combinations. >>> >>> But glad that you already found a solution. >>> >>> Greetings, >>> Andreas >>> >>> On 2019-03-26 13:43, Marco Antônio Ferreira Pedrosa wrote: >>> >>> Hi Alexandre, >>> >>> It worked perfectly! As you said: >>> >>> 1) I made a unique list from the years and generate a new feature. Then >>> used it as the coverage layer for atlas. >>> 2) For each symboloy (rule-based): >>> (@atlas_pagename = "Year") AND ("Quality" = 'Excelent') >>> (@atlas_pagename = "Year" ) AND ("Quality" = 'Good') >>> so on... >>> >>> As you see I changed it a little bit, so I can use the "current" year >>> from Atlas. >>> >>> Tnks a lot! >>> >>> P.S: PORTUGAL CARALHO!!!! (sou Brasileiro haha) >>> >>> -- >>> >>> Marcão >>> >>> Em seg, 25 de mar de 2019 às 20:58, Alexandre Neto < >>> senhor.n...@gmail.com> escreveu: >>> >>>> You need to create a layer, with a column called year, with each year >>>> in a row. The layer does not need to have a geometry. Use that layer as the >>>> coverage layer for atlas. >>>> >>>> For the layer you want to filter by year, create a rule-based >>>> symbology, and use the following rule/expression: >>>> >>>> attribute(@atlasfeature, 'yea >>>> r') = "year" >>>> >>>> This compares the current atlas feature field year, to the layer year >>>> column, and renders the features only if the years match. >>>> >>>> Hope it helps. >>>> >>>> Alexandre Neto >>>> >>>> A seg, 25/03/2019, 13:50, Marco Antônio Ferreira Pedrosa < >>>> marcomot...@gmail.com> escreveu: >>>> >>>>> Hi all, >>>>> >>>>> Sorry if s a silly question! >>>>> >>>>> How to generate an atlas by a value in the attibute table? (i.e: >>>>> Year). QGIS Atlas would generate one map for each attribute value but not >>>>> group by year. >>>>> >>>>> For each year, I want to show the features with a categorized >>>>> symbology (same for all years, but I want to show just the features from >>>>> that year). >>>>> >>>>> tnks in advance! >>>>> _______________________________________________ >>>>> Qgis-user mailing list >>>>> Qgis-user@lists.osgeo.org >>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >>>> >>>> -- >>>> Alexandre Neto >>>> --------------------- >>>> @AlexNetoGeo >>>> http://sigsemgrilhetas.wordpress.com >>>> http://gisunchained.wordpress.com >>>> >>> >>> _______________________________________________ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >>> >> -- Alexandre Neto --------------------- @AlexNetoGeo http://sigsemgrilhetas.wordpress.com http://gisunchained.wordpress.com
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user