topic Re: vbscript find if a field value exists in QlikView

vbscript find if a field value exists

Thu, 08 Mar 2012 11:45:33 GMT

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 — Thu, 08 Mar 2012 11:49:15 GMT

Hi,

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

Regards,

Jagan.

Thu, 08 Mar 2012 12:06:36 GMT

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

Thanks in advance

jagan — Thu, 08 Mar 2012 12:10:30 GMT

Hi,

Please check the example

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

fieldindex( 'Name', 'John Doe' )

Regards,

Jagan.

Thu, 08 Mar 2012 12:23:20 GMT

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 — Thu, 08 Mar 2012 12:32:01 GMT

Hi,

This is a qlikview method, not VBScript method.

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

Regards,

Jagan.