topic Re: Selecting multiple values in GetFieldSelection in App Development

Selecting multiple values in GetFieldSelection

Wed, 28 Dec 2016 18:24:36 GMT

Hi All,

I am using the [Response ID] <> GetFieldSelection([Response ID)] to get the sum(score) for the value selected which are unselected in Response ID list box, however unable to achieve it.

Need assistance. I am using personal edition, hence cannot open others workbook.

Re: Selecting multiple values in GetFieldSelection

sunny_talwar — Wed, 28 Dec 2016 18:31:58 GMT

May be this:

If(GetSelectedCount([Response ID]) = 0, Sum(score), Sum({<[Response ID] = e([Response ID])>} score))

Re: Selecting multiple values in GetFieldSelection

Wed, 28 Dec 2016 18:51:43 GMT

Hi Sunny,

The syntax did not work.

Let me explain the requirement

We have a field named Response ID.

For example we have 100 response Id. We need to show a Combo chart with Bar showing the score just one responded which is selected and a referene showing the avg score of other 99 respondent.

I hope this helps.

Re: Selecting multiple values in GetFieldSelection

sunny_talwar — Wed, 28 Dec 2016 18:53:14 GMT

Did it give incorrect result? Did it give you any error? What exactly did not work?

Re: Selecting multiple values in GetFieldSelection

Wed, 28 Dec 2016 19:22:51 GMT

Hi Sunny,

Please find the attached workbokk for reference.

Re: Selecting multiple values in GetFieldSelection

sunny_talwar — Wed, 28 Dec 2016 19:27:44 GMT

This?

Expression used for line

If(GetSelectedCount([Response ID]) = 0,

Sum({<Category -= {'Option'}>}Weightage)/Count({<Category -= {'Option'}>}Question),

Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Weightage)/Count({<Category -= {'Option'}, [Response ID] = e([Response ID])>}Question))

Re: Selecting multiple values in GetFieldSelection

Wed, 28 Dec 2016 19:39:52 GMT

Hi Sunny,

Under Capabilty Line Measure, we are expecting the avg score to be as 66.66 i.e. 400/6

Re: Selecting multiple values in GetFieldSelection

sunny_talwar — Wed, 28 Dec 2016 19:56:16 GMT

Try this:

Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Aggr(Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Weightage), [Response ID], Category))/

Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Aggr(Count({<Category -= {'Option'}, [Response ID] = e([Response ID])>}Question), [Response ID], Category))

Re: Selecting multiple values in GetFieldSelection

Wed, 28 Dec 2016 20:04:21 GMT

Roger Sir !!! Bulls Eye

Correct Syntax, got the desired O/P