topic Re: How to create expression with multiple "options" in App Development

How to create expression with multiple "options"

Sat, 16 Nov 2024 10:33:01 GMT

Hi all!

I'm trying to write an expression that will bring the results for all of my data that was collected at the following facilities: HMail, HPrint and WM. These facilities are independent, i.e. only 1 facility can be tied to each data point.

I used the Set Analysis Wizard and tried the following

Count({$<[QID_Data.Incident Type]={'Internal Issue'},[QID_Data.Facility Entered]={'WM'}>}{$<[QID_Data.Incident Type]={'Internal Issue'},[QID_Data.Facility Entered]={'HMail'}>}{$<[QID_Data.Incident Type]={'Internal Issue'},[QID_Data.Facility Entered]={'HPrint'}>}[Action #])

The equation is treating the data like they all have to match. How can I write it so that my results will bring me anything that contains HMail -or - HPrint - or WM? If I were to use the "Exclusion" piece, I would need it to exclude "CH" and "LF".

Thanks in advance!

Meg

Re: How to create expression with multiple "options"

sunny_talwar — Mon, 27 Jun 2016 16:27:41 GMT

Can you try this:

Count({$<[QID_Data.Incident Type] = {'Internal Issue'}, [QID_Data.Facility Entered] = {'WM', 'HMail', 'HPrint'}>} [Action #])

Re: How to create expression with multiple "options"

Mon, 27 Jun 2016 16:29:22 GMT

thank you!

Re: How to create expression with multiple "options"

danansell42 — Mon, 27 Jun 2016 16:31:54 GMT

Hi Meg

I know the + sign works as an OR operator.

I think the following is what you're looking for...

Count({$<[QID_Data.Incident Type]={'Internal Issue'}>+<[QID_Data.Facility Entered] = {'WM','HMail','HPrint'}>} [Action #])

Thanks

Dan