Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
andrea_derossi
Partner - Contributor II
Partner - Contributor II

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

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

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

Hi Oleg,

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

Thanks,

Oliver

mongolu
Creator
Creator

or you can use the new functionality "DynamicUpdateCommand".