Drop down menu to select range of values

304
1
Jump to solution
05-06-2022 12:50 PM
Ed_
by MVP Regular Contributor
MVP Regular Contributor

Hello,

How can I create a drop down selection menu such that it has the ability to select range of values. For example,

variable = 1, 2, 3, 4, 5, 6, 7

And the ranges in the drop down menu would  look like this:

1 = Minimal

2-3 = Low

4-5 = Moderate

6-7 = High

How can I write an expression syntax for this in predefined filter> advance?

0 Kudos
1 Solution

Accepted Solutions
Ed_
by MVP Regular Contributor
MVP Regular Contributor

I found a solution as follows:

  1. Select a predefined filter
  2. Select advanced
  3. Type [FIELD] = 1 > click apply > rename to Minimal
  4. Type [FIELD] = 2 OR 3 > click apply > rename to Low
  5. Type [FIELD] = 4 OR 5 > click apply > rename to Moderate
  6. Type [FIELD] = 6 OR 7 > click apply > rename to High
  7.  

View solution in original post

0 Kudos
1 Reply
Ed_
by MVP Regular Contributor
MVP Regular Contributor

I found a solution as follows:

  1. Select a predefined filter
  2. Select advanced
  3. Type [FIELD] = 1 > click apply > rename to Minimal
  4. Type [FIELD] = 2 OR 3 > click apply > rename to Low
  5. Type [FIELD] = 4 OR 5 > click apply > rename to Moderate
  6. Type [FIELD] = 6 OR 7 > click apply > rename to High
  7.  
0 Kudos