topic User Defined Function in QlikView

User Defined Function

bnichol — Fri, 23 Jul 2010 16:06:13 GMT

Is there a way that I can create a public function in the "Edit Modules" section, so that it can be called as an expression.

When I try this, I get the error "Bad function name" in the Edit Expression window.

Any suggestions?

brenner_martina — Fri, 23 Jul 2010 17:05:39 GMT

Hi,

did you name your macro? p.e. Sub MyFunction ... End Sub - you can enter Macros and use them in the script either or in the objects.

Otherwise you can enter function as a variable and use them like fields.

bnichol — Fri, 23 Jul 2010 17:24:44 GMT

I've defined the function like...

Public function test1(mbName)
...
test1 = false
end function

The function returns a boolean and I'm trying to use it in a Calculation Condition.