Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Referencing VBScript functions

How do your eference VBScript functions in a QlikView table?

The VBScript Function is named Findvalue(str)

2 Replies
tseebach
Partner - Creator III
Partner - Creator III

Hi, I would love to be able to do this. But I'm sorry to let you know you cannot!

wizardo
Creator III
Creator III

hmm,

many vbscript functions have an equivilant in QV

in your case the, instead of Findvalue(str) vbscript function you can use this function:

--- taken from the inside QV help ----

FindOneOf ( text , characterset [ , n] )

Returns the position of the n :th occurrence in the string text of any of the characters found in the string characterset . If n is omitted, the position of the first occurrence is returned. If there no matching string is found, 0 is returned.

Example:

findoneof( 'my example text string', 'et%s') returns '4 '

findoneof( 'my example text string', 'et%s', 3) returns '12 '

findoneof( 'my example text string', '¤%&') returns '0 '

Mansyno