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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Like this?

Capture.PNG


FieldIndex('E_CREATED_BY_SYSTEM',E_CREATED_BY_SYSTEM)

View solution in original post

14 Replies
prat1507
Specialist
Specialist

=SubStringCount(SubField(Concat(Distinct{1} E_CREATED_BY_SYSTEM,','),GetFieldSelections(E_CREATED_BY_SYSTEM),1),',')+1

Anonymous
Not applicable
Author

Thanks Pratyush,

But its not working...

qlikcheepirishe
Creator
Creator

Firstly create a variable such as =getfieldselections([Fieldname])

v1.PNG

Then in listbox or textobject write this function

tb1.PNG

bijay.jha

prat1507
Specialist
Specialist

Hi Bijay

Can you please share a sample app.

Regards

Pratyush

Anonymous
Not applicable
Author

qlikcheepirishetty, Thanks for your reply


But sorry to let you know that it's not working.


Hi Pratyush,


Use the below field and make a list box, that's it.



E_CREATED_BY_SYSTEM

CLARIFY

GOLD

LOIS

QUOTO

SESAM

SITE-BULK-UPLOAD

tresesco
MVP
MVP

Like this?

Capture.PNG


FieldIndex('E_CREATED_BY_SYSTEM',E_CREATED_BY_SYSTEM)

Anonymous
Not applicable
Author

Getselectvalue.png

whatever I will select in Listbox, Position number will reflect on Text Box

Anil_Babu_Samineni

You must use same formula in Gauge chart then it will reflect for sure

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

But Anil,

I wanted to reflect the same in TextBox.

If it works on Gauge chart then surely it will work on Textbox.

but I didn't get the answer...

Thanks