topic is it possible by macro to add one row on table? in QlikView

is it possible by macro to add one row on table?

andrea_derossi — Sat, 25 Apr 2009 22:27:26 GMT

Hi all

is it possible by macro to add one row on table?

I konw that the exampol is not correct but it is the gool.

function Debug()

set v = ActiveDocument.GetVariable("step")

v = v+1

concatenate (DebugList)

Load

'$(QvWorkPath)'&''&'$(_File)' as ErrorList.Filename,

$(DebugIDMax) +$(v) as DebugID,

today() as DebugDate,

... autogenerate(1) ;

end function;

Thanks all

is it possible by macro to add one row on table?

Oleg_Troyansky — Sun, 26 Apr 2009 01:20:51 GMT

No, macros don't quite work this way. There is a coming new functionality in ver. 9 that will allow something like this.

What you can do now is have your macro initiate a "Partial Reload" and organize your load script in a way that would add data conditionally. If you download my QlikView Explorer, you can find an example of how it's done.

regards,

Oleg

is it possible by macro to add one row on table?

Fri, 16 Oct 2009 20:24:36 GMT

Hi Oleg,

I'm using v9 now. Can you describe the method you mentioned? It'd be exactly what I need.

Thanks,

Oliver

is it possible by macro to add one row on table?

mongolu — Sun, 18 Oct 2009 11:28:22 GMT

or you can use the new functionality "DynamicUpdateCommand".