topic Re: Position of value in field in QlikView

Position of value in field

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

Is there anyway to get a textbox to return the position a value has in a field - this is specifically for use in a QV report where I am looping over said field.

E.g. This is my field and its values:

Dim
A
B
C
D
E

My report is going to loop over field 'Dim', so I'll have one report for 'A', one for 'B' etc

What I want from my text box, is firstly for it to display the field value:

=Dim

But then for it to tell me the number of the field value, according to its order.

So I would end up with

A - 1

B - 2

C - 3

D - 4

E - 5

Even better if it could tell me the total values too, so:

A - 1/5

B - 2/5

C - 3/5

D - 4.5

E - 5/5

Re: Position of value in field

tresB — Thu, 10 Aug 2017 09:18:51 GMT

May be like:

=Dim&'-'&FieldIndex('Dim', Dim)&'/'&FieldValueCount('Dim')

Re: Position of value in field

jessica_webb — Thu, 10 Aug 2017 09:21:43 GMT

Thank you so much - that works perfectly

Do you know what order the field index works on? Is it load order, or alphabetical...

EDIT: Worked it out myself! Load order it is!