topic Re: Current selections in text box in QlikView

Current selections in text box

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

Hi all, i have my current selections displayed in a text box. A problem i have is that 5 fields are ticked to have 'one selected value', this causes the current selection text bix to be full as soon as the qvw is opened.

What i am looking for is a way to exclude the fields that have one selected value against them.

I know i can prefix them and use the hideprefix in the script, the prtoblem is i want them to appear in the proper current selection box, just not the one i have created in the text box.

The text box is for the users to see quickly the actual selections they have chosen, any preselected selections can be seen from the in built current selections.

the text box has the following expression..

=if(len(GetCurrentSelections())=0,'No Selections',

if(len(GetCurrentSelections())>165,'Too many selections to display','Current Selections :'& GetCurrentSelections(' | ','=')))

what i am wondering if there is an IF statement i can add in to say, if the current selections include any field starting in 'FX' then do not show.

I have attached a sample..

Any help would be appreciated.

Thanks in advance

Re: Current selections in text box

vamsee — Wed, 19 Sep 2018 15:40:09 GMT

HI Chris,

You can try GetFieldSelections(FieldName) and be more specific about the columns you want to consider

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselect…

Re: Current selections in text box

hopkinsc — Wed, 19 Sep 2018 15:49:45 GMT

Hi, thanks for your reply.

Thats going to be difficult to do as i want all other fields to be considered, just not the ones starting in FX.

Re: Current selections in text box

prieper — Wed, 19 Sep 2018 16:27:52 GMT

hmmm,

you may do a combination of REPLACE and GETCURRENTSELECTIONS:

aircode for textbox:

=REPLACE(GETCURRENTSELECTIONS(),

'Dim1: ' & GETFIELDSELECTIONS(Dim1), '')

might have to be adjusted to your formatting, though.

HTH

Peter

Re: Current selections in text box

hopkinsc — Wed, 19 Sep 2018 17:16:15 GMT

Thats great, thanks Peter, I have managed to get what i want using multiple replaces.