Excel Style Formulas in QGIS

9 views

Skip to first unread message

Mark Arnup

unread,

Jul 9, 2025, 2:45:33 AM7/9/25

to QGIS Australia User Group

Dear All.

I have an odd one. I’m trying to create a mathematical formula in a field in QGIS like you would see in an Excel Spreadsheet, buy taken values from other fields and giving an answer in a separate field live as you are entering the values via dropdown lists. Is this possible?

John Bryant

unread,

Jul 9, 2025, 2:56:26 AM7/9/25

to australian-qg...@googlegroups.com

Hi Mark, you can use a Value Map in the attributes form to generate a dropdown, and you can use a virtual field to have a dynamic value based on an expression.

See the attached GeoPackage. The layer has a default style that contains a value map and a virtual field demonstrating it. It uses a text expression but you could also use a math expression.

On Wed, 9 Jul 2025 at 14:45, Mark Arnup <mark....@gmail.com> wrote:

Dear All.

I have an odd one. I’m trying to create a mathematical formula in a field in QGIS like you would see in an Excel Spreadsheet, buy taken values from other fields and giving an answer in a separate field live as you are entering the values via dropdown lists. Is this possible?

--
You received this message because you are subscribed to the Google Groups "QGIS Australia User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to australian-qgis-use...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/australian-qgis-user-group/41a2dd83-3b19-4700-a320-5a7d87869f57n%40googlegroups.com.