https://issues.qgis.org/https://issues.qgis.org/favicon.ico2006-08-21T12:27:41ZQGIS Issue TrackingQGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134402006-08-21T12:27:41ZGavin Macaulay -gavin@macaulay.co.nz
<ul></ul><p>Can you provide some more details on what you mean?</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134412006-08-21T21:51:14ZRedmine Admin
<ul></ul><p>Often I need to calculate new field values based on existing layer attribute table fields. For this issue it would be great if I do have a field calculator. Think about the following situation:<br />1. open layer attribute table.<br />2. start digitizing.<br />3. add a new field NEWFIELD to the opened attribute table if you don't like to overwrite existing table field values.<br />4. select the field you want to calculate values for. In our case NEWFIELD.<br />5. open the field calculator. (Opening the field calculator via button like the add field button).<br />6. select a math function to calculate the NEWFIELD value. p.e. NEWFIELD = sin(EXISTINGFIELD1) + cos(EXISTINGFIELD2)<br />7. stop digitizing.</p>
<p>Please let me know whether my details do explain my idea.</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134422007-07-21T19:27:51ZTim Suttontim@linfiniti.com
<ul></ul>Changed to minor under the following scheme:
<ul>
<li>blocker - bugs that should block the release. Since we are going to release pretty much 'come what may' I would like no bugs</li>
<li>allocated to this category without consultation with me and / or PSC</li>
<li>critical - bugs that cause the application to crash or corrupt data</li>
<li>major - application features that do not function at all</li>
<li><strong>minor</strong> - features that function but imerfectly e.g. labels placing incorrectly</li>
<li>trivial - gui useability issues or small issues with the documentation, install notes etc.</li>
</ul> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134432008-02-12T07:02:08ZPaolo Cavallinicavallini@faunalia.it
<ul></ul><p>Looks like you want to reimplement a spreadsheet within QGIS? This can be done eg in OOo, the issue could be how to recall a spreadsheet easily (single-click) from QGIS?</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134442008-02-12T22:50:02ZHorst Düsterhorst.duester@kappasys.ch
<ul></ul><p>Replying to [comment:5 pcav]:</p>
<blockquote>
<p>Looks like you want to reimplement a spreadsheet within QGIS? This can be done eg in OOo, the issue could be how to recall a spreadsheet easily (single-click) from QGIS?</p>
</blockquote>
<p>It's not the idea to reimplement a spreadsheet! But it is very helpful to calculate new column values. P.e. for Classification of objects. The first part of my request, add a new column, is realised (PostGIS Layer)</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134452008-07-03T06:05:34Zcdavilam -cdavilam@orangecorreo.es
<ul></ul><p>Replying to [comment:5 pcav]:</p>
<blockquote>
<p>Looks like you want to reimplement a spreadsheet within QGIS? This can be done eg in OOo, the issue could be how to recall a spreadsheet easily (single-click) from QGIS?</p>
</blockquote>
<p>Although it can be done in a spreadsheet, it would be very useful enabling it within QGIS. Otherwise it's necessary to remove the layer/close project->open dbf in OOo->edit and save->reload in QGIS/reopen project->rearrange simbology (if you don't have it saved), which is a very annoying process.</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134462008-07-03T06:58:14ZPaolo Cavallinicavallini@faunalia.it
<ul></ul><p>Isn't this implemented as a python plugin? Should we close this?</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134472008-07-03T09:39:03ZHorst Düsterhorst.duester@kappasys.ch
<ul></ul><p>Replying to [comment:9 pcav]:</p>
<blockquote>
<p>Isn't this implemented as a python plugin? Should we close this?</p>
</blockquote>
<p>Which plugin do you mean?</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134482009-01-31T01:48:13ZPaolo Cavallinicavallini@faunalia.it
<ul></ul><p>Table Manager, by Borys. Please check whether it has the functions you need.</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134492009-01-31T10:54:31Zcdavilam -cdavilam@orangecorreo.es
<ul></ul><p>No, it has a <em>Calculate</em> button, but currently not functional (to be implemented...)</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134502009-01-31T14:03:29ZBorys Jurgiel
<ul></ul><p>Exactly. It's on very hign position on my TODO list, but I haven't touch it yet. I'll do my best to implement it in February.</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134512009-07-10T03:59:16ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>I would like also to see this feature implemented, not only because I think is useful, but also because <del>the missing of this tool</del> is one of that things that (other software) users do notice when using for the first time QGis.</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134522009-07-10T05:13:57ZHorst Düsterhorst.duester@kappasys.ch
<ul></ul><p>Replying to [comment:14 lutra]:</p>
<blockquote>
<p>I would like also to see this feature implemented, not only because I think is useful, but also because <del>the missing of this tool</del> is one of that things that (other software) users do notice when using for the first time QGis.</p>
</blockquote>
<p>+1</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134532009-07-10T06:10:36ZMartin Dobiaswonder.sk@gmail.com
<ul></ul><p>What operations and functions should such field calculator support?</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134542009-07-10T08:33:22ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Replying to [comment:16 wonder]:</p>
<blockquote>
<p>What operations and functions should such field calculator support?</p>
</blockquote>
<p>I know that make comparisons it is always bad, but (if you want to stay out of the arc* playground) I would suggest to have a look at the "field calculator" of gvSIG. It has many commands, every one has his own short description, so you may want to have a look to the program (I cannot find references of all the commands, not even in the manual, pag. 220 [<a class="external" href="ftp://downloads.gvsig.org/gva/descargas/manuales/gvSIG-1_1-man-v1-en.pdf">ftp://downloads.gvsig.org/gva/descargas/manuales/gvSIG-1_1-man-v1-en.pdf</a> here]).</p>
<p>See the attached image.</p>
<p>Among the others you can calculate areas, perimeters and lenghts without having to create a new shapefile like ftools requires.</p>
<p>Command list:</p>
<pre>
ABS
ACOS
AREA
ASIN
ATAN
CEIL
COS
< >
/
E
==
EXP
<=
<
LOG
MAX
MIN
-
>=
>
PERIMETER
PI
+
POW
RANDOM
ROUND
SIN
SSQRT
TAN
*
TODEGREES
TONUMBER
TORADIANS
TOSTRING
</pre> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134552009-07-10T22:58:03ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul></ul><p>Note: a field calculator is on my (implementation) roadmap for this summer.</p>
<p>Marco</p> QGIS Application - Feature request #243: Add a feature to calculate field values in attribut tableshttps://issues.qgis.org/issues/243?journal_id=134562009-09-30T04:38:31ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed</i></li></ul><p>A field calculator is available from <br /><a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/59a486bd713e7dad3779fe392d98522c4cace344" title="[FEATURE]: A field calculator, accessible with a button in the attribute section of the vector pr...">59a486bd</a> (SVN r11736) on (more operators will follow)</p>
<p>Marco</p>