topic Re: Field Indeх in QlikView

Field Indeх

Anonymous — Thu, 02 Jun 2016 14:30:03 GMT

Hi,

Is it possible to use alternate state in the Field Indeх formula?

Thank you in advance,

Larisa

swuehl — Thu, 02 Jun 2016 14:33:39 GMT

What should be the use case for that?

Anonymous — Thu, 02 Jun 2016 14:53:35 GMT

There is a variable vMin '=Min(FieldIndex('FieldName', FieldName))'

This variable is defined in Variable Overview Window with the equal sign. For some reason it is important.

The variable vMin is used as an argument in some other formulas in the application.

So I need to canculate the variable vMin based on the alternat state.

swuehl — Thu, 02 Jun 2016 15:03:48 GMT

Have you tried applying the alternate state identifier to the Min() function?

=Min({AS} FieldIndex('FieldName', FieldName))

Anonymous — Thu, 02 Jun 2016 15:56:27 GMT

Thank you, swuel!