Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It will be easier to debug if you can share a sample file with small data.
You can try something like below..
Considering that your have list boxes (Dimensions) Year and Country
='Selected Year = '&GetFieldSelections(Year) & ' '&'Selected Country ='& GetFieldSelections(Country)
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
Try Below...
=' Current Selections: ' &if(isnull(GetCurrentSelections()), 'Nothing selected', GetCurrentSelections(' | ', ': ', ','))