topic Re: How to avoid using DocumentTitle() and use parameter in the sub-routine to execute the piece of code? in QlikView

How to avoid using DocumentTitle() and use parameter in the sub-routine to execute the piece of code?

qlikviewforum — Thu, 20 Mar 2014 07:42:14 GMT

How can I avoid using the DocumentTitle() in the below sub-routine? I know we can pass the parameter in sub-routine but is it possible to pass the parameter to execute the piece of code? Please suggest!

SUB Calendar

[CALENDAR]:
LOAD
Period as AsOfPeriod
Resident [Calendar];

if DocumentTitle()='XYZ' then

Concatenate([CALENDAR])
LOAD
Period,
'Dummy' as Check
Resident [CALENDAR];

end if

END SUB

Re: How to avoid using DocumentTitle() and use parameter in the sub-routine to execute the piece of code?

qlikviewforum — Thu, 20 Mar 2014 09:47:43 GMT

Any update on this?

Re: How to avoid using DocumentTitle() and use parameter in the sub-routine to execute the piece of code?

jonathandienst — Thu, 20 Mar 2014 09:58:41 GMT

Not sure if I've understood you correctly, but is this it?

SUB Calendar(zSuppress)

[CALENDAR]:

LOAD

Period as AsOfPeriod

Resident [Calendar];

if zSuppress = 0 then

Concatenate([CALENDAR])

LOAD

Period,

'Dummy' as Check

Resident [CALENDAR];

end if

END SUB

Then call it using CALL Calendar(0) or CALL Calendar(1)

HTH

Jonathan

Re: How to avoid using DocumentTitle() and use parameter in the sub-routine to execute the piece of code?

qlikviewforum — Thu, 20 Mar 2014 12:04:57 GMT

Excellant Jonathan! Thank you

Can you give me one more example by passing the 2 or more parameters.