topic Re: Getselected group name values??? in QlikView

Getselected group name values???

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Getselected group name values???

Anonymous — Thu, 24 Nov 2016 04:29:23 GMT

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,

Re: Getselected group name values???

hemanthaanichet — Thu, 24 Nov 2016 04:40:34 GMT

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

Re: Getselected group name values???

jonathandienst — Thu, 24 Nov 2016 04:48:30 GMT

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))], ', ')

=GetFieldSelections([$(=GetCurrentField(cTest))])

The expression editor may incorrectly flag these as errors, but you can ignore that.