topic Re: i need to change the alignment in the code in QlikView

i need to change the alignment in the code

sbkumar — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: i need to change the alignment in the code

Sue_Macaluso — Thu, 20 Jun 2019 19:58:34 GMT

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

Re: i need to change the alignment in the code

rwunderlich — Thu, 20 Jun 2019 21:09:12 GMT

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

Re: i need to change the alignment in the code

sbkumar — Fri, 21 Jun 2019 02:42:18 GMT

qlikview