Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

List Index value from list box

Good Noon Everyone,

Since Yesterday I M trying to find out the list index value from Listbox as per the selection.

But I haven't  succeeded in my attempt.

Please, anyone can help me, in fixing the issue.

Thanks in Advance

Listindex.png

I want the result = 3

Even I used Getfieldselection still not able to get the required answer.

14 Replies
tresesco
MVP
MVP

Capture.PNG

Anil_Babu_Samineni

Why Not?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Thanks, Tresesco

It's working only when I keep the sort order in Load Order Mode ( Original Mode ).

What if I sort the list box in ascending or descending, it must change the value accordingly.

Thanks..

tresesco
MVP
MVP

You can do that using sortable aggr(). However, that would not reflect the change in listbox sort order change. You can use conditional expressions each for ascending and descending and use a button to see the change in index on changed sort order.

Anonymous
Not applicable
Author

I have used the formula

=Aggr ( FieldIndex ('E_CREATED_BY_SYSTEM',E_CREATED_BY_SYSTEM),-E_CREATED_BY_SYSTEM)

but not working , Please give me the formula if you are saying some things else