QGIS Labeling- str() and int()

Question

I am new to QGIS (ESRI shop at work). I am attemping to concatenate fields in the label expression

field1 = number
field2 = number

label expression I tired but fails

str(field1) + " - " + str(field2)

it says its not valid. This would work in ArcMap... how is it different?

score 5 · Accepted Answer · answered Apr 11 '18 at 15:36

5

You need to change three things about your query:

So your query should look something like this:

to_string("field1") + ' - ' + to_string("field2")

answered Apr 11 '18 at 15:36

karpfen

2

Shouldn't it be: to_string("field1") || ' - ' || to_string("field2") – HeikkiVesanto Apr 11 '18 at 15:47
1

Yes, maybe that would be nicer, since it's proper SQL. It works both in QGIS, though. – karpfen Apr 11 '18 at 15:58
1

Cool. Must be a new feature. Back in my day (1.8) we had to use the double bar. – HeikkiVesanto Apr 11 '18 at 16:15
1

Yep, seems like it. https://www.qgis.org/en/site/forusers/visualchangelog260/index.html#feature-additional-expressions-types-and-options – karpfen Apr 12 '18 at 08:58

score 4 · Answer 2 · answered Apr 11 '18 at 15:33

4

You can use the concatenate operator || or the concat function (under strings).

answered Apr 11 '18 at 15:33

Ian Turton

still says invalid... field1 + concat(" -" + field2) – NULL.Dude Apr 11 '18 at 15:37
concat('-',field2) – Ian Turton Apr 11 '18 at 15:38

2 Answers2