topic Re: Temp Table in Macro in QlikView

Temp Table in Macro

Mon, 26 Nov 2012 16:06:05 GMT

Hi Guys can i create a temp table inside a macro .... ??? i do not want to make it in Qlikview Data model or in some other database. Just want to store some values in a field ????? Or may be can i store the values in some field using macro

Re: Temp Table in Macro

christian77 — Mon, 26 Nov 2012 17:09:56 GMT

Yes it's possible to modify QV data model tables with a macro.

You also can use variables from the variable panel in the macro module.

Rem Dynamic Data Update

sub Update
SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE * SET Discount = if(Discount >= 35, 0, if (City='Stockholm', Discount + 5, Discount + 2)) WHERE Country = 'SE'")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub

sub Insert
SET Result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO * (Country, City) VALUES (DK, Copenhagen), (NO, Oslo)")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub

sub Delete
SET Result = ActiveDocument.DynamicUpdateCommand ("DELETE FROM CITY WHERE IsNull (Discount)")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub

You need the APIGuide.

Re: Temp Table in Macro

christian77 — Mon, 26 Nov 2012 17:15:07 GMT

also, you can load a table from anywhere and then state the clause:

Drop Table TableName;

Drop field from table ...;

Drop fields ...; Drop Tables ...;

in the script.

Re: Temp Table in Macro

Mon, 26 Nov 2012 17:39:14 GMT

Hi Christian

Thanks for the quick reply but still the field is not getting updated ....

am i missing something .. ??????

Re: Temp Table in Macro

Mon, 26 Nov 2012 18:06:49 GMT

Hey Christan

I am able to update the field but when i am doing a refersh .. the value is getting back to the old value...

but i do not want that .. is it possible???

Re: Temp Table in Macro

christian77 — Tue, 27 Nov 2012 08:29:55 GMT

Ok. Refresh means reload. Of course, what did you expect with a new reload?

Listen,

When you update your table, export it to a qvd or txt or whatever in the same macro.

You can export only what you want and concatenate in the next refresh (reload)

luck