Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement to return the selected values of the group i created. I created a listbox with cyclic dimension.
I want to get the selected values of the group that i am selecting. please find the attached sample data.
Thanks.
Gautham
I assume you want to retrieve the selected/possible values from the current field of the cyclic. I am not sure how you want to use these values, but this will display the values for cyclic cTest in a textbox:
=Concat(distinct [$(=GetCurrentField(cTest))], ', ')
or
=GetFieldSelections([$(=GetCurrentField(cTest))])
The expression editor may incorrectly flag these as errors, but you can ignore that.
Hi Gautham,
Apply Following in your 2nd Text Box (Current Group Name values selected??):
='Month: ' & GetFieldSelections(Month) & ' & Age : ' & GetFieldSelections(AGE_FILTER)
That above expression will give you values of selected 'Month' and selected 'Age_Filter'
Apply following for 1st text Box:
='Year:' & GetFieldSelections(Year)& ' , Month: ' & GetFieldSelections(Month) & ' , Quarter: ' & GetFieldSelections(Quarter)
Thanks,
Hi Gautham,
Use Getfieldselection() function
Try this:
1. ='Year:' & getfieldselections(Year) & ' , Month: ' & getfieldselections(Month) & ' , Quarter: ' & getfieldselections(Quarter)
2. ='Month: ' & getfieldselections(Month) & ' & Age : ' & getfieldselections(AGE_FILTER)
Refer the attachment below
Regards
Hemanth
I assume you want to retrieve the selected/possible values from the current field of the cyclic. I am not sure how you want to use these values, but this will display the values for cyclic cTest in a textbox:
=Concat(distinct [$(=GetCurrentField(cTest))], ', ')
or
=GetFieldSelections([$(=GetCurrentField(cTest))])
The expression editor may incorrectly flag these as errors, but you can ignore that.