topic Re: Using GetFieldSelections in Set Analysis in App Development

Using GetFieldSelections in Set Analysis

Danny_Langley — Wed, 17 May 2017 01:50:22 GMT

Hi everyone,

My eyes are going crossed trying to figure this out. Please help!

I have a filter pane (Occupation) that I want to use to dynamically create a set analysis filter.

The following set statement is successful if I only select ONE value from my Occupation filter:

count({<Occupation ={"$(=GetFieldSelections(Occupation,','))"}>}EMPLOYEE_COUNTER)

However, if I select more than one value then it can't evaluate successfully because the filter string that's built is missing quotes (' ')....so I added the Chr(39) below but can't get it to work at all now

count({<Occupation ={"$(=Chr(39)&GetFieldSelections(Occupation,Chr(39)& ','&Chr(39))&Chr(39))"}>}EMPLOYEE_COUNTER)

The goal is to have a statement that looks like the follows after the user selects 'Doctor', 'Nurse', and 'Firefighter' from the Occupation filter.

count({<Occupation = {'Doctor','Nurse','Firefighter'}>}EMPLOYEE_COUNTER)

Or if you can think of a better way to do it in general than what I'm doing, I'm all ears as well.

Thanks in advance!

Re: Using GetFieldSelections in Set Analysis

Anonymous — Wed, 17 May 2017 03:16:58 GMT

Hi,

You can try this: (i removed the excess " ")

=count({<Occupation={$(=chr(39)&GetFieldSelections(Occupation,chr(39)&','&chr(39))&chr(39))}>}EMPLOYEE_COUNTER)

Re: Using GetFieldSelections in Set Analysis

vinieme12 — Wed, 17 May 2017 05:22:22 GMT

But why do you even need to add set analysis for that?

Showing associated data based on selections is Natural behavior you don't need set analysis for that??

If you still need set analysis try using P () , but I must re-iterate this is not required

Example

count({<Occupation = P (Occupation)>}EMPLOYEE_COUNTER)

To concat selections try below in textbox

=$(=chr (39)&concat (distinct fieldname, chr(39)&','&chr(39))&chr(39))

Re: Using GetFieldSelections in Set Analysis

VishalWaghole — Wed, 17 May 2017 09:57:02 GMT

You can try below expression,

=if(isNull(GetFieldSelections(Occupation)),0,sum(employee_count))

Then try by selecting occupation one by one.

Re: Using GetFieldSelections in Set Analysis

Danny_Langley — Wed, 17 May 2017 13:00:40 GMT

Thanks so much Vineeth! I knew someone would ask why I even need this because it's natural behavior....ha. I'm going to be working with the Occupation field as a data island to build the filter string to apply elsewhere for a calculation. Anyway, using the P function did the trick and is much simpler! Thanks so much.

Re: Using GetFieldSelections in Set Analysis

Danny_Langley — Wed, 17 May 2017 17:30:20 GMT

Hi Yddona - thanks for your response - this worked as well. I just needed to remove the " ". It's always the small things that get you!