Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-29 Thread Andrea Giudiceandrea
Totò wrote > So the mistake I was making is using a virtual field (maybe it's a bug?) Hi Salvatore, you are right: it seem the expression is not correctly evaluated in a virtual field (using the Field Calculator with the "Create a new field" and "Create virtual field" options both checked).

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-29 Thread Totò
Totò wrote > what am I doing wrong? Hi Andrea, I finally understood the mistake. First you need to create the 'zona_fill2' field and then populate it with the expression: if ("zone" is empty, attribute (get_feature_by_id (@layer, $ id -1), 'zona_fill2'), "area") So the mistake I was making is

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread Andrea Giudiceandrea
Totò wrote > I have a CSV file [0], how to get the "zona_fill" field? > The "zona_fill" field is the result of the fill-down of the "zona" column. Hi Salvatore, I've imported your csv file, copied the features to a new scratch memory layer, and created a new field named 'zona_fill2' using the

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread Totò
Andrea Giudiceandrea wrote > Totò wrote >> I have a CSV file [0], how to get the "zona_fill" field? >> The "zona_fill" field is the result of the fill-down of the "zona" >> column. > > Hi Salvatore, > > I've imported your csv file, copied the features to a new scratch memory > layer, and created

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread Totò
Alexandre Neto wrote > Sorry, > > Can you be more clear? It's not clear to me what you are trying to > accomplish. how to repeat the first non-null value down so that all cells are populated? this operation is called fill-down and in SQL I can get it like this: select b.data, b.rowid,

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread David Strip
On 3/28/2021 2:05 PM, Alexandre Neto wrote: Sorry, Can you be more clear? It's not clear to me what you are trying to accomplish. Here's some sample data he posted on Github:

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread chris hermansen
Totò and list, On Sun, Mar 28, 2021 at 10:04 AM Totò wrote: > I have a CSV file [0], how to get the "zona_fill" field? > The "zona_fill" field is the result of the fill-down of the "zona" column. > Seems to me you are trying to calculate "zona" to "zona_fill". If that's the case, you need to

Re: [Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread Alexandre Neto
Sorry, Can you be more clear? It's not clear to me what you are trying to accomplish. Alexandre Neto A domingo, 28/03/2021, 18:04, Totò escreveu: > I have a CSV file [0], how to get the "zona_fill" field? > The "zona_fill" field is the result of the fill-down of the "zona" column. > > I

[Qgis-user] Fill-down with QGIS expressions

2021-03-28 Thread Totò
I have a CSV file [0], how to get the "zona_fill" field? The "zona_fill" field is the result of the fill-down of the "zona" column. I could use various tools external to QGIS, but it would be useful to be able to do this with field calc expressions; does anyone have any ideas on how to make it?