topic Re: Using GetCurrentSelections with textbox in QlikView

Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 07:09:06 GMT

Hello,

I am trying to create a textbox that displays my current (single) selection using the following expression:

=getcurrentselections (chr(13), chr(13), chr(13), 10 )

The problem that I have is that the output also dispays the column name of the selection. How can I remove this?

Thanks,

Robert

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 07:29:49 GMT

can you please let me know what the output look like?

regards,

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 08:04:03 GMT

With the expression mentioned above, the output is:

Column_name

Currently_selected_value

What I want is to remove the column name, so that only the selected value is displayed.

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 08:06:24 GMT

Hi,

i dnt think it makes sense to remove column name....in case of multiple selections, how do u know what is selected in which field ?

what exactly u trying to achieve?

Regards

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 08:10:14 GMT

I want to create a Project report, and I want the report to dynamically display the project name as a header to the report. What I then do is select the project I want the report to display.

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 08:11:27 GMT

Hi,

Use getfieldselections(ProjectName)

Regards

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 08:44:54 GMT

you can achieve this with subfield around the getfieldselections

regards

Re: Using GetCurrentSelections with textbox

Thu, 18 Oct 2012 10:17:59 GMT

Try to put this in a text box:

=replace(subfield(getcurrentselections ( Month ),':',2),',',chr(10))

Regards