Field Selection Order in QlikSense

[mohitd910]

Hi ,

I got struck in a problem, need help on below.

Input :- I have an ID Field. Values are  from 1 to 50.

Desired Output :- What I want, when I  am selecting  Multiple IDs  and Selection order is 35, 28,33,27,39.

I want to show same order in Textbox. Is it possible ?

Please help on above.

@rob Wunderlich, @hic, @Gysbert_Wassenaar, @rwunderlich

#Qlik Sense #Qlik Sense # Business #Qlik Sense Functions #Qlik Sense Actions

[hic]

No, it is not possible. The order in which the selections are made is not stored anywhere, since it doesn't affect the result.

HIC 

[mohitd910]

@hic  Thanks for your reply, but It will effect my requirement and result when we are playing conditional show and hide of measure.  Using selection order and  substring  i want to fix my first measure  and second measure i will maintain dynamically.

[mohitd910 · Accepted solution]

I have find some solution of finding first Selection and Last Selection.

Concat(
if(index('$(vLastSelectionOfDynamicExp)',
subfield(getfieldselections([Sub Category],',',vDynamicCount),',',ValueLoop(1,vFieldDymanicCount,1))
)>0,NULL(),
subfield(getfieldselections([Sub Category],',',vDynamicCount),',', ValueLoop(1,vFieldDymanicCount,1))
),' ')

[Vegar]

You have hidden some of your solution logic inside variables. What is the content of your solution variables? 

[mohitd910]

Hi ,

I hope this will be helpful for you.

vLastSelectionOfDynamicExp=concat({$1} [Sub Category],',')

vDynamicCount=count({1}  [Sub Category])

vFieldDymanicCount=count([Sub Category])

Regards,

Mohit Dahiya