Double visibility Issue

Double visibility Issue

Anonymous
Not applicable
600 Views
4 Replies
Message 1 of 5

Double visibility Issue

Anonymous
Not applicable

Hi all,

 

Please see attached picture and block and see if it is possible to make lookups related to each other. 

 

In this example, I want "Number of Transom" lookup be set to 0 even if we set "Number of mullions" to one so it jumps to zero too.

 

I am getting better in Multi-lookup. There were no errors after setting up the lookups in first go. Thanks again Libbya for this lesson.

 

Cheers,

 

Double Visibility Issue.jpg

 

0 Likes
601 Views
4 Replies
Replies (4)
Message 2 of 5

Libbya
Mentor
Mentor

On the Lookup Input table of the Bridge double lookup, on the 0-0 row, under the Position1Y column, I changed the value(s) from '0' to '0,1,2,3'.  That way, regardless of what the mullions is set to, if the transom is set to 0, the transom turns off.  The number of mullions does not jump to zero, though.  It is remembered and displayed again if the transom is set to 1 or 2.

0 Likes
Message 3 of 5

Anonymous
Not applicable

Wow, Thanks Libbya,

 

I did not know you can have multiple values separated by comma in input values.

 

Well I understand what you mean for jumping to 0.

 

This brings up a question in my mind that what else I can put in the value of an input parameter in lookup.

 

1- A Single Value

2- Multiple values separated by commas

3- value inside prantesis [This you showed me in a block that for example (0,) means any value except zero, am I right about the expression?]

4-?

 

Is there a list or page you can refer me to it so I can go and study? or it is just couple more, can you list them here?

 

It looks like no mater how much you learn there is still room to grow 😉

 

Thanks, 

0 Likes
Message 4 of 5

Libbya
Mentor
Mentor

There is a page in the help that describes the syntax although, as someone pointed out recently, it has a couple typos on it.  The gist is as follows;

 

You can have multiple values separated by commas.  You can also have ranges.  A range will be enclosed in either brackets, parentheses, or one of each.  Within the brackets/parentheses you will typically have two numbers separated by a comma.  The first number is the lower limit and the second number is the upper limit.  If the range is missing one of the two numbers, it is limitless in that direction.  A parentheses next to the limit number means that it does not include the limit, but includes all numbers up to the limit.  A bracket includes the limit value.  Ok, here are some examples.

 

0,1,2,3 = any time the variable equals specifically 0 or 1 or 2 or 3.

 

(0,1) = all numbers between 0 and 1 not including 0 or 1.

[0,1) = all numbers between 0 and 1 including 0 but not including 1

[0,1],4 = all numbers between 0 and 1 including 0 and 1 and also including 4.

(0,) = any value greater than 0 but not including 0

(,4] = any value equal to or less than 4.

(,4],6,[7,8] = any value equal to or less than 4 and 6 and any number between 7 and 8 including 7 and 8.  

 

In a similar way, you can also make multiple rows that each have the same lookup property.  The ranges are easier, but multiple rows become necessary when you are using a parameter that has a value list.  Bear in mind that multiple values that equal a specific lookup property row will make the table read only.  That means that the table can only be used as the input table and not the output table of a double lookup.  

 

0 Likes
Message 5 of 5

Anonymous
Not applicable

Perfect!

 

Appreciated!

0 Likes