i need to change the alignment in the code

[sbkumar]

=

chr(10) &

if(GetSelectedCount(IMS_ID_Searchable) <= 1 and GetSelectedCount(Area) = 0 and GetSelectedCount(Region) = 0 and GetSelectedCount(District) = 0 and GetSelectedCount(Territory) = 0 and GetSelectedCount(POD) = 0 and GetPossibleCount(District) > 1 , if(vAppVersion = 2, 'NATION', 'DISTRICT')) &
if(IsNull(GetCurrentSelections()), '',
if(GetSelectedCount(IMS_ID_Searchable) <= 1 and GetSelectedCount(Area) = 0 and GetSelectedCount(Region) = 0 and GetSelectedCount(District) = 0 and GetSelectedCount(Territory) = 0 and GetSelectedCount(POD) = 0 and GetPossibleCount(District) > 1, ' | ') &
if(GetSelectedCount(District) = 0 and GetPossibleCount(District) = 1, 'District : ' & Concat(DISTINCT District, ', ') & ' | ') &
replace(GetCurrentSelections(chr(13)&chr(10) , ' : ' , ' ; ' , 6 ), chr(13) & Chr(10), ' | '))

i want the selectiosn shouldbe in specific order like  IMS_ID_Searchable :,Region,District,Area,Nation,Market,Submarket,Brand

[Sue_Macaluso]

@sbkumar Are you using QlikView or Sense? I would like to move it into the correct product forum. 

[rwunderlich]

I can't think of a way to sort the output of GetCurrentSelections().  As an alternative, can you build up the list for specific fields using the order you want? Something like:

=if(GetSelectedCount(ProductName)
  ,'ProductName: ' & concat(DISTINCT ProductName, ', '))
& if(GetSelectedCount(Country)
  ,' | Country: ' & concat(DISTINCT Country, ', '))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[sbkumar]

qlikview