topic FieldIndex returns 0 from IE Plug-In in QlikView

FieldIndex returns 0 from IE Plug-In

michael_anthony — Tue, 08 Mar 2011 03:48:30 GMT

Hi,

I have a field called Currency_Select which is controlled by user (Always One Selected Value checked) and a separate unattached field PrimaryCurrency which has a subset of currencies (eg. AUD, USD and EUR). I want to check whether the selected value in Currency_Select is one of the PrimaryCurrency options.

Working in QV Desktop on the Server I have created an expression:

If(FieldIndex('PrimaryCurrency',Only(Currency_Select))>0,Only(Currency_Select),'N/A')

This works fine and returns the expected value. BUT when I look at the same from the IE Plug-in I get N/A as the FieldIndex function fails to work. Does anyone else have similiar problems with FieldIndex, and is there a solution?

Thanks, Michael

FieldIndex returns 0 from IE Plug-In

pover — Tue, 08 Mar 2011 07:12:55 GMT

Never hurts to make sure that the Plug-in, QV Desktop and QV Server are all the same exact version.

Regards.

FieldIndex returns 0 from IE Plug-In

rwunderlich — Tue, 08 Mar 2011 07:24:01 GMT

FieldIndex() had some problems on earlier version of QV9 on the server. What version and SR is your server at?

FieldIndex returns 0 from IE Plug-In

michael_anthony — Tue, 08 Mar 2011 23:53:30 GMT

Still on 8.5 for Developer, QVS and PlugIn. Believe we're at SR6.

I've instead used a work around expression of Count(DISTINCT If(PrimaryCurreny = Only(Currency_Select),PrimaryCurrency)) > 0 to give same outcome.

FieldIndex returns 0 from IE Plug-In

rwunderlich — Wed, 09 Mar 2011 04:52:57 GMT

Yes, it was definately broken in 8.5. Was fixed sometime in 9. Glad you found a workaround.