Bsrhrki

Is this homebrew Wind Wave spell balanced?

How much cash can I safely carry into the USA and avoid civil forfeiture?

What is Niska's accent?

Can I spend a night at Vancouver then take a flight to my college in Toronto as an international student?

Why isn't the definition of absolute value applied when squaring a radical containing a variable?

How can I practically buy stocks?

Don’t seats that recline flat defeat the purpose of having seatbelts?

Why do Computer Science majors learn Calculus?

Unexpected email from Yorkshire Bank

Normal Map bad shading in Rendered display

Binary Numbers Magic Trick

Is there a way to get a compiler for the original B programming language?

How to get a plain text file version of a CP/M .BAS (M-BASIC) program?

Can someone publish a story that happened to you?

In order to check if a field is required or not, is the result of isNillable method sufficient?

Realistic Necromancy?

How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?

How to verbalise code in Mathematica?

A ​Note ​on ​N!

Fizzy, soft, pop and still drinks

How to reduce LED flash rate (frequency)

Combinable filters

Exchange,swap or switch

What's the polite way to say "I need to urinate"?

QGIS 2.18 label by expression concatenate field strings

How to use buffer() in QGIS Value Relation fieldHow to calculate percentages using QGIS field calculator expression?Limiting available values in dropdown field of QGIS form according to value selected in previous field?QGIS Multiple CASE WHEN/THEN Statements for Expression Based LabelsCan I make Points-in-polygon output to the attribute table of polygon layer?Splitting text attribute using conditional function QGIS 2.18.13Concatenate Label Values Fails to Calculate AggregateCreating new field with values from different fields QGISAdding text to label expression in QGIS?Labeling expressions on AGOL with Arcade for certain features

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

For a building layer I have an attribute table with several fields for the building type where data was entered with a manually created form using checkboxes. Example:

Production: 1 = (yes), 0 = (no)
Office: 1 = (yes), 0 = (no)
Storage: 1 = (yes), 0 = (no) 

and so on...

Now I want to label this layer with first letter of the respective building type. Like e.g: Production = P, Office = O, Storage = S and so on...

In case its only only one type its easy. I create a new field and use an expression like this:

CASE WHEN "Production" = 1 THEN 'P' ELSE '' END

But many buildings refer to multiple types, so I'd like to have expression that wraps everything up. It should check the state of the check box fields and concatenate the respective letters in a new field:
Examples:

P/S

O/S

P/O

P/O/S

How to do so?

qgis labeling expression concatenation

share|improve this question

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are the slashes necessary?
  
  – Erik
  Apr 24 at 11:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, would be nice to have. If it gets too complicated like that, only spacing might be sufficient as well
  
  – Philippo Storino
  Apr 24 at 12:01
  

  
  
  
  

add a comment | 

2

For a building layer I have an attribute table with several fields for the building type where data was entered with a manually created form using checkboxes. Example:

Production: 1 = (yes), 0 = (no)
Office: 1 = (yes), 0 = (no)
Storage: 1 = (yes), 0 = (no) 

and so on...

Now I want to label this layer with first letter of the respective building type. Like e.g: Production = P, Office = O, Storage = S and so on...

In case its only only one type its easy. I create a new field and use an expression like this:

CASE WHEN "Production" = 1 THEN 'P' ELSE '' END

But many buildings refer to multiple types, so I'd like to have expression that wraps everything up. It should check the state of the check box fields and concatenate the respective letters in a new field:
Examples:

P/S

O/S

P/O

P/O/S

How to do so?

qgis labeling expression concatenation

share|improve this question

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are the slashes necessary?
  
  – Erik
  Apr 24 at 11:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, would be nice to have. If it gets too complicated like that, only spacing might be sufficient as well
  
  – Philippo Storino
  Apr 24 at 12:01
  

  
  
  
  

add a comment | 

For a building layer I have an attribute table with several fields for the building type where data was entered with a manually created form using checkboxes. Example:

Production: 1 = (yes), 0 = (no)
Office: 1 = (yes), 0 = (no)
Storage: 1 = (yes), 0 = (no) 

and so on...

Now I want to label this layer with first letter of the respective building type. Like e.g: Production = P, Office = O, Storage = S and so on...

In case its only only one type its easy. I create a new field and use an expression like this:

CASE WHEN "Production" = 1 THEN 'P' ELSE '' END

But many buildings refer to multiple types, so I'd like to have expression that wraps everything up. It should check the state of the check box fields and concatenate the respective letters in a new field:
Examples:

P/S

O/S

P/O

P/O/S

How to do so?

qgis labeling expression concatenation

share|improve this question

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

Production: 1 = (yes), 0 = (no)
Office: 1 = (yes), 0 = (no)
Storage: 1 = (yes), 0 = (no) 

CASE WHEN "Production" = 1 THEN 'P' ELSE '' END

P/S

O/S

P/O

P/O/S

share|improve this question

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

share|improve this question

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

edited Apr 24 at 12:07

JGH

13.9k21339

edited Apr 24 at 12:07

JGH

13.9k21339

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

asked Apr 24 at 11:51

Philippo StorinoPhilippo Storino

365

1 Answer
1

active

oldest

votes

3

You can evaluate each condition using if(), combine the outputs using ||, and remove the last slash using a regex expression:

regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')

share|improve this answer

answered Apr 24 at 12:05

JGHJGH

13.9k21339

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So '/$' finds me the last / - or any other character? Nice to know.
  
  – Erik
  Apr 24 at 12:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked prefectly! Thanks a lot!!!
  
  – Philippo Storino
  Apr 24 at 12:19
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  @Erik $ is for end of line, / is for /, so the combination looks for a / followed by end of line (i.e the last one only)
  
  – JGH
  Apr 24 at 12:21
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f320717%2fqgis-2-18-label-by-expression-concatenate-field-strings%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

You can evaluate each condition using if(), combine the outputs using ||, and remove the last slash using a regex expression:

regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')

share|improve this answer

answered Apr 24 at 12:05

JGHJGH

13.9k21339

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So '/$' finds me the last / - or any other character? Nice to know.
  
  – Erik
  Apr 24 at 12:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked prefectly! Thanks a lot!!!
  
  – Philippo Storino
  Apr 24 at 12:19
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  @Erik $ is for end of line, / is for /, so the combination looks for a / followed by end of line (i.e the last one only)
  
  – JGH
  Apr 24 at 12:21
  
  

  
  
  
  

add a comment | 

3

You can evaluate each condition using if(), combine the outputs using ||, and remove the last slash using a regex expression:

regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')

share|improve this answer

answered Apr 24 at 12:05

JGHJGH

13.9k21339

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So '/$' finds me the last / - or any other character? Nice to know.
  
  – Erik
  Apr 24 at 12:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked prefectly! Thanks a lot!!!
  
  – Philippo Storino
  Apr 24 at 12:19
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  @Erik $ is for end of line, / is for /, so the combination looks for a / followed by end of line (i.e the last one only)
  
  – JGH
  Apr 24 at 12:21
  
  

  
  
  
  

add a comment | 

You can evaluate each condition using if(), combine the outputs using ||, and remove the last slash using a regex expression:

regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')

share|improve this answer

answered Apr 24 at 12:05

JGHJGH

13.9k21339

regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')

share|improve this answer

answered Apr 24 at 12:05

JGHJGH

13.9k21339

answered Apr 24 at 12:05

JGHJGH

13.9k21339

answered Apr 24 at 12:05

JGHJGH

13.9k21339