Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Display getcurrentselection in a row

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.

4 Replies
Not applicable

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

MK_QSL
MVP
MVP

You can try something like below..

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

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

veidlburkhard
Creator III
Creator III

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

MK_QSL
MVP
MVP

Try Below...

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