topic Save table to file on server in QlikView

Save table to file on server

tseebach — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I've found a issue with my budget appllication when used via AJAX. It needs to save the new budget to a file on the server, so another application can read it.

The Action export, works nicely in the Developer, but pipes out a file to the browser in AJAX, instead on the file system.

And this macro does not seem to work in AJAX:

set doc = ActiveDocument
set obj = doc.GetSheetObject("CH416")
obj.ServerSideExport "budget.csv",";"

Any ideas?

Re. :Save table to file on server

martin59 — Tue, 11 May 2010 12:54:21 GMT

Hello,

I think macros doesn't work with AJAX.

Regards,

Martin.

Re. :Save table to file on server

tseebach — Tue, 11 May 2010 13:49:40 GMT

Not true, I use a macro to recalcualte some input fields, that works nicely 🙂

This code works:

Set objRowCount = Doc.Fields("RecId").GetPossibleValues
For r = 0 to objRowCount.Count - 1
' Select a single item
Doc.Fields("RecId").Select objRowCount.Item(r).text
' Get the possible ids

' Calculate the change
strForecast = Round(objvIncrease.GetContent.String * objForecast.Item(r).text)
Doc.Fields("Forecast").SetInputFieldValue objRowCount.Item(r).text-1,Cstr(strForecast)
Doc.Fields("Forecast").Clear
Doc.Fields("RecId").Clear
Next

Re. :Re: Re. :Save table to file on server

martin59 — Wed, 12 May 2010 11:33:05 GMT

Good to know, I had got this information by QlikTech France when i had issues with macros and Ajax.

Martin

Re. :Re: Re. :Save table to file on server

tseebach — Wed, 12 May 2010 11:56:53 GMT

I would love to have a list of what works in ajax. I know everybody is trying to kill macros, but we need this kind of environment to create exceptional solutions.

Re. :Re: Re. :Re: Re. :Save table to file on server

martin59 — Wed, 12 May 2010 12:57:11 GMT

I'm completely agree with you !

And in passing, your web site is very interesting !

Thank you