topic Display getcurrentselection in a row in QlikView

Display getcurrentselection in a row

n1ef5ng1 — Mon, 10 Mar 2014 07:39:58 GMT

Hi see attached for clarity.

I have came up with a dashboard name executive dashboard

I have created a textbox where when user select some fields for Product example. It will state Executive dashboard for product : Apple

However when user select another option, the textbox will show multiple row instead of single row. is there any way I can tell Qlikview to show alll user optiions in one single row for cosmetic purposes.

(I have stretch the box to the maximum)

Thanks.

Re: Display getcurrentselection in a row

Mon, 10 Mar 2014 07:47:25 GMT

It will be easier to debug if you can share a sample file with small data.

Re: Display getcurrentselection in a row

MK_QSL — Mon, 10 Mar 2014 07:53:33 GMT

You can try something like below..

Considering that your have list boxes (Dimensions) Year and Country

='Selected Year = '&GetFieldSelections(Year) & ' '&'Selected Country ='& GetFieldSelections(Country)

Re: Display getcurrentselection in a row

veidlburkhard — Mon, 10 Mar 2014 08:05:55 GMT

Hi Bennn,

if you use getcurrentselections () without any parameter it should show the values in one row. You can set different parameters in order to structure the output according to your needs.
See QV Help file with the definition of getcurrentselections () as: getcurrentselections ([RecordSep [, TagSep [,ValueSep [, MaxValues]]]]).

Try and play with the different possibilities.

Regards

Burkhard

Re: Display getcurrentselection in a row

MK_QSL — Mon, 10 Mar 2014 08:17:45 GMT

Try Below...

=' Current Selections: ' &if(isnull(GetCurrentSelections()), 'Nothing selected', GetCurrentSelections(' | ', ': ', ','))