topic Re: List Index value from list box in QlikView

List Index value from list box

Anonymous — Wed, 21 Jun 2017 09:39:31 GMT

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

I want the result = 3

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

Re: List Index value from list box

prat1507 — Wed, 21 Jun 2017 09:56:25 GMT

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

Re: List Index value from list box

Anonymous — Wed, 21 Jun 2017 10:13:05 GMT

Thanks Pratyush,

But its not working...

Re: List Index value from list box

qlikcheepirishe — Wed, 21 Jun 2017 11:08:52 GMT

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

Then in listbox or textobject write this function

bijay.jha‌

Re: List Index value from list box

prat1507 — Wed, 21 Jun 2017 11:19:56 GMT

Hi Bijay

Can you please share a sample app.

Regards

Pratyush

Re: List Index value from list box

Anonymous — Thu, 22 Jun 2017 02:48:18 GMT

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

Re: List Index value from list box

tresB — Thu, 22 Jun 2017 05:23:11 GMT

Like this?

FieldIndex('E_CREATED_BY_SYSTEM',E_CREATED_BY_SYSTEM)

Re: List Index value from list box

Anonymous — Thu, 22 Jun 2017 05:27:40 GMT

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

Re: List Index value from list box

Anil_Babu_Samineni — Thu, 22 Jun 2017 05:30:31 GMT

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

Re: List Index value from list box

Anonymous — Thu, 22 Jun 2017 05:32:58 GMT

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

Re: List Index value from list box

tresB — Thu, 22 Jun 2017 05:33:53 GMT

Re: List Index value from list box

Anil_Babu_Samineni — Thu, 22 Jun 2017 05:35:04 GMT

Why Not?

Re: List Index value from list box

Anonymous — Thu, 22 Jun 2017 05:40:56 GMT

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

Re: List Index value from list box

tresB — Thu, 22 Jun 2017 05:46:14 GMT

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.

Re: List Index value from list box

Anonymous — Thu, 22 Jun 2017 06:14:51 GMT

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