[Qgis-user] Fill-down with QGIS expressions

[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,
       b.zona,  b.nuts2,
      (select a.zona
	   from fill_down_es as a
	   where a.rowid <= b.rowid  
	   and 
	   a.zona <> 'NULL' 
	   order by rowid desc limit 1 )  as zona_fill2
from fill_down_es as b

I'm looking for a way to do this with QGIS expressions.

<http://osgeo-org.1560.x6.nabble.com/file/t378656/fill_down2.png> 



-----
https://pigrecoinfinito.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html