topic Call Subroutine based on file name in QlikView

Call Subroutine based on file name

zagzebski — Fri, 05 Feb 2016 19:29:39 GMT

I need to call a specific subroutine based on the name of the file. Somthing like this:

If (DocumentName()= 'Model', 'CALL BASE', 'CALL MI')

Looking for help on how to write the script

Thanks,

Zag

petter — Fri, 05 Feb 2016 19:37:51 GMT

In the script it should be like this I guess:

IF DocumentName() = 'Model' THEN
    CALL BASE
ELSE
    CALL MI
END IF

But if the logic needs to work inside a LOAD statement it must be like this:

(I guess this is not what you are looking for)

LOAD
    If( DocumentName() = 'Model', BASE() , MI() ) AS aCalc
....
;

The BASE and MI must then be Functions implemented in VBScript which can be called directly from a LOAD SCRIPT without a problem.

zagzebski — Fri, 05 Feb 2016 19:43:30 GMT

So simple. Thanks!

Steve