topic Re: Current Selections box in QlikView

Current Selections box

Thu, 04 Oct 2012 19:36:42 GMT

Is there any way to list values from a field - line by line in a Current Selections box instead of values appearing as one continuous string separated by commas?

Re: Current Selections box

Anonymous — Fri, 05 Oct 2012 01:35:30 GMT

Nope, not really.

If it's something that you'd like to invest a bit of time in you could create this using a Text Object and GetFieldSelections() and concat() the selections with a carriage return chr() as the separator.. but it sounds like overkill.

Re: Current Selections box

nilesh_gangurde — Fri, 05 Oct 2012 06:05:09 GMT

Hi dalejames,

You can use the below function in the text object.

=GetCurrentSelections()

Regards,

Nilesh Gangude

Re: Current Selections box

jagan — Fri, 05 Oct 2012 11:20:07 GMT

Hi,

This option is not available for Current selection box, but you can do this by using GetFieldSelections() and formatting the result as required, using a Text object you can display the selections.

Hope this helps you.

Regards,

Jagan.

Re: Current Selections box

Fri, 05 Oct 2012 19:13:48 GMT

Many thanks each of you for your quick responses. I’m trying to show the values that I have de-selected from a List Box containing [Diagnosis 1]. I’ve created a Text Object and tried concatenating with:

=concat(GetFieldSelections([Diagnosis 1])&chr(13))

I’d like to see:

NOT

T39.1 Poisoning by 4-Aminophenol derivatives

N39.0 Urinary tract infection, site not specified

F20.0 Paranoid schizophrenia

But I get the following result:

NOT T39.1 Poisoning by 4-Aminophenol derivatives, N39.0 Urinary tract infection, site not specified, F20.0 Paranoid schizophrenia

Which still appears as one string. As this may contain several values, I need to break up the values to make them more readable, one diagnosis per line. Have I got the syntax correct in my concat?Any further ideas?

Thanks again

Re: Current Selections box

MayilVahanan — Fri, 05 Oct 2012 21:37:14 GMT

Try like this

=GetFieldSelections([Diagnosis 1],chr(13))

And you can minimize the text object. As per value..