[Qgis-user] Coding in the field calculator - how to ask for value one line above

[Bernhard Ströbl]

Hi,

not that I am aware of BECAUSE: the order of rows in a table is random 
and being manipulatible through the user (sort, filter).
A script could easily step through the table and keep one row's Y value 
in a variable until the next row's X value is determined BUT I doubt 
that the output of this script would be reproducible, so unless you 
explain better what you are aiming at doing your wish seems nonsense to me.

Bernhard

Am 06.11.2014 12:15, schrieb Florian Konrad:
> Hi there,
> i got an attribute-table with thousands of lines and several columns. I want to check every Line if the value in column „X" is „a“ and if the value in column „Y“ but one line above is „b“ at the same time. So i want to write something like this in the field calculator to generate a new column:
>
> CASE WHEN „X" = ‚a' AND "the value one row above in column Y" = ‚b' THEN '1‘ END
>
> so that i can mark these lines that im searching for with ‚1‘ in a new column… Is there a command for "the value one row above in coloum Y“ ? Or do i have to do this some other way?
> I hope i explained my problem well enough and would appreciate any help.
>
> Greetings
> Florian
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> __________ Information from ESET Mail Security, version of virus signature database 10679 (20141106) __________
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>



__________ Information from ESET Mail Security, version of virus signature database 10679 (20141106) __________

The message was checked by ESET Mail Security.
http://www.eset.com