nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple if, for multiple values

Iron_Mark

Hi,

I am failing calculating multiple if and I can't understand why.

I tried multiple syntax but this one maybe will let you understand better what I would like to do.

I want to: if select a productname and a surface it should return a value, otherwise another, in the same way, if another product is selected with the same surface, it has to return another value, otherwise again another value.

if(selected(${prod}, 'product1') and selected(${surface}, 'surface1'), '10', '20'), if(selected(${prod}, product2') and selected(${surface}, 'surface2'), '100', '200')

I always get an error. Any help would be appreciated.

Thank you in advance

タグ付きの投稿をもっと見る

Accepted answers

JA7

You have 4 if statements, so you need to have 4 closing parenthesis at the end.

if(selected(${prod}, 'Roundup_ProActive') and selected(${surface}, 'surface1'), '10',
if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '20', if(selected(${prod}, 'product2') and selected(${surface}, 'surface1'), '100', if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '200', '11'))))

All comments

JA7

The second if statement is technically a part of the first if statement (it is the 'else'). So you will need to move the closing parenthesis for the first if statement to the very end.

if(selected(${prod}, 'product1') and selected(${surface}, 'surface1'), '10', if(selected(${prod}, product2') and selected(${surface}, 'surface2'), '100', '200'))

ZenMasterZeke

What are you doing this in, Arcade, Survey123, etc? You have a default else value (20) in your first statement, if the condition is not true, so the second if statement would make no logical sense as an alternative to the first; also, can't be on the same line, although unclear if that's how it's set in your code.

What it appears you're doing is setting some value such that
if selection = Jedi then Light, else Dark
and also saying
if selection = human, then organic, else droid

This can work as separate if statements, but if you're setting one value/text/etc, the second one will always overwrite the first no matter what. You might look at nesting them.

Iron_Mark

Hi Jennifer,

By doing this it sais that "if requires 3 arguments. Only 4 provided"

JA7

you need your first if condition (is this true), your second if condition (if the first one is false, is this one true), and then your default answer (if both are false provide this)....so those are the three arguments you need. Make sure you don't have anything else in your calculation.

Iron_Mark

Hi Greg,

Nice creativity with the example.

I am doind this with survey123 as the community suggest. I am completely stuck with this now..

this is the further I could go.....

if(selected(${prod}, 'product1') and selected(${surface}, 'surface1'), '10', if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '20', '11'))

By doing this it works (the alternative value 11 doesn't make sense, but at least make it works).

Still it is missing the whole second part with product2 and surface2. If I copy and paste the first part changing the names it gives an error....

Iron_Mark

if(selected(${prod}, 'Roundup_ProActive') and selected(${surface}, 'surface1'), '10', if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '20', if(selected(${prod}, 'product2') and selected(${surface}, 'surface1'), '100', if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '200', '11'))

It only works the first part (with a non sense element such 11):

if(selected(${prod}, 'product1') and selected(${surface}, 'surface1'), '10', if(selected(${prod}, 'product1') and selected(${surface}, 'surface2'), '20', '11'))

Really don't know what to do.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.