topic Re: Field Selection Order in QlikSense in App Development

Field Selection Order in QlikSense

mohitd910 — Sat, 16 Nov 2024 17:32:28 GMT

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

Re: Field Selection Order in QlikSense

hic — Tue, 02 Feb 2021 08:47:30 GMT

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

Re: Field Selection Order in QlikSense

mohitd910 — Tue, 02 Feb 2021 09:14:06 GMT

@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.

Re: Field Selection Order in QlikSense

mohitd910 — Wed, 03 Feb 2021 06:10:26 GMT

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))
),' ')

Re: Field Selection Order in QlikSense

Vegar — Wed, 03 Feb 2021 06:31:24 GMT

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

Re: Field Selection Order in QlikSense

mohitd910 — Wed, 03 Feb 2021 07:37:03 GMT

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