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

[qlikviewforum]

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

[qlikviewforum]

Any update on this?

[jonathandienst]

Hi

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

[qlikviewforum]

Excellant Jonathan! Thank you

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