topic Array position in QlikView

Array position

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I have a problem and I don't know how to solve it with chart functions.

Suppose that I have a field with this possible values:

John

Michael

Rose

Danny

Then I could use concat( {<Name=>} distinct [Name] ,',') to have the next value in a text field or function:

John,Michael,Rose,Danny

Well, I'm looking for a way to show the order of selected item over field Name in that list.

Examples:

If I select Jhon I want see 1

If I select Rose I want see 3

Does anybody knows how can I solve this?

Thanks

Nicole-Smith — Tue, 02 May 2017 14:56:28 GMT

The match() function returns the number corresponding to a value in a list. You would write the function something like this:

=match(Name, $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))

=match('Danny', $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))

The dollar sign expansion is needed around the concat() so that it just returns the list of values to search over.

Anil_Babu_Samineni — Tue, 02 May 2017 15:12:53 GMT

I doubt, whether it will return correct number. I am assume, For Rose Match returns 4 not 3. I haven't check may be it will return 4 only.

Or May be Data island table will work for this case

Anonymous — Tue, 02 May 2017 15:32:02 GMT

Thanks Nicole! It's fit for my solution