topic Re: Variable using in Fieldindex() in QlikView

Variable using in Fieldindex()

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

Hi all,

I have to use variable in Fieldindex function.

For example: =fieldindex('Fieldname, $(vCurrency)&amount).

Here vCurrency has $, £, €. and there are 3 buttons like USD, GBP, EUR.

Here Fieldname has $amount, £amount and €amount.

If i click USD buttion $ should display at vCurrency dynamically and GBP, EUR respectively.

Regards,

Nihhal.

Re: Variable using in Fieldindex()

sunny_talwar — Fri, 22 Jul 2016 10:17:16 GMT

Are you missing a single quote here or is that just a typo?

=FieldIndex('Fieldname', $(vCurrency)&amount)

Re: Variable using in Fieldindex()

marcus_sommer — Fri, 22 Jul 2016 10:18:40 GMT

Have a look here: Missing Manual - FieldIndex()

- Marcus

Re: Variable using in Fieldindex()

nihhalmca — Fri, 22 Jul 2016 10:19:55 GMT

Not working sunny. Thanks for swift response.

Re: Variable using in Fieldindex()

nihhalmca — Fri, 22 Jul 2016 10:22:31 GMT

Thanks for response Marcus however, this is not relevant to my requirement.

Re: Variable using in Fieldindex()

alexandros17 — Fri, 22 Jul 2016 10:28:37 GMT

Fieldindex return the position of the field value into the fildname, but values in your tables are stored with the currency type?

Re: Variable using in Fieldindex()

marcus_sommer — Fri, 22 Jul 2016 10:29:02 GMT

I'm not so sure about it then fieldindex will return only a number - nothing else. Which result do you expect?

Maybe you need something like this:

fieldvalue('Field', fieldindex('Fieldname', $(=$(vCurrency)&amount)))

- Marcus

Re: Variable using in Fieldindex()

swuehl — Fri, 22 Jul 2016 10:32:22 GMT

Not sure what you want to achieve.

The syntax is

Syntax:

FieldIndex(fieldname , value )

FieldIndex - script function ‒ QlikView‌

I assume your values are numbers, right? And you want to get the index in the symbol table for your number looking e.g. in the symbol table of $Amount, i.e. both the field name and the value need to be looked up dynamically before evaluating FieldIndex() function?

Like this when using button '$' / USD:

FieldIndex('$Amount', $Amount)

after replacing the variable?

Re: Variable using in Fieldindex()

nihhalmca — Fri, 22 Jul 2016 10:38:09 GMT

Hi Sunny - Its working with small changes.

Fieldindex('Fieldname, vCurrency&'amount').

Regards,

Nihhal.

Re: Variable using in Fieldindex()

susovan — Fri, 22 Jul 2016 10:44:25 GMT

Hi Nihhal,

Try this,

fieldindex('Fieldname', $(vCurrency)&'amount')