Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gauthamchilled
Creator
Creator

Getselected group name values???

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Anonymous
Not applicable

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,

hemanthaanichet
Creator III
Creator III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein