vbscript find if a field value exists

[#1]

Hi everyone

I need some help with vbscript.

Is there a way to find if a value of a field from my database exists also in qlikview document.

I want to create a buuton which search in qlikview doc and finds a specific field value.

Could anyone help me?

[jagan]

Hi,

Use the FieldIndex() for finding whether a value exists in the field in Qlikview.

Regards,

Jagan.

[#3]

Could you please write me the syntax cause I cannot find it.

Thanks in advance

[jagan]

Hi,

Please check the example

Returns value >0, if 'John Doe' exists in Name field.

fieldindex( 'Name', 'John Doe' )

Regards,

Jagan.

[#5]

Sorry for the inconvenience but I get an error

I have a field: CustomerId and a variable which I get it from the DB: dbCustomerId

I write variable=ActiveDocument.FieldIndex("CustomerId", dbCustomerId )

and i get the error: Object doesn't support this property or method: 'ActiveDocument.FieldIndex'

What I do wrong?

[jagan]

Hi,

This is a qlikview method, not VBScript method.

Please find the attachment for solution, hope this what you are searching.

Regards,

Jagan.