topic macro function in load script in QlikView

macro function in load script

Sun, 28 Jun 2009 16:51:35 GMT

Hi,

I have a macro function that counts the number of charts.
if i call this function in load script with let v_noc = numberofcharts();

Unfortunately I don't get the value. Anyone an idea?

Thanks.

macro function in load script

Anonymous — Sun, 28 Jun 2009 19:46:57 GMT

In general, you can use macro functions in the script, although there could be some restrictions. In your case, I think, the problem is that the charts technically don't exist yet during the the reload. As a workaround, you can create a varaible that keeps the number of charts, and use it in the load script.

macro function in load script

rwunderlich — Tue, 30 Jun 2009 08:20:40 GMT

If your macro is trying to navigate through the ActiveDocument, as of 8.2/8.5 most of the ActiveDocument properties do not exist during script execution. The new "Document Functions" are meant to fill this gap, although I don't see anything for number of charts.

-Rob