issue when running a macro

Tue, 21 May 2013 23:07:24 GMT

Hi,

I have a requirement where I need to force an always one selected value but I need to clear it as soon as I leave the sheet. I found a macro on Qlikview community which is doing my job. The macro is below

sub alwaysoneselect

set qvobj = ActiveDocument.GetSheetObject("LB427")

set myfield = qvobj.GetField

set fieldprop = myfield.GetProperties

fieldprop.OneAndOnlyOne = true

myfield.setproperties fieldprop

end sub

sub removeoneselected

set qvobj = activedocument.getsheetobject("LB427")

set myfield = qvobj.getfield

set fieldprop = myfield.getproperties

fieldprop.OneAndOnlyOne = false

myfield.setproperties fieldprop

ActiveDocument.ClearAll true

end sub

I call the alwaysoneselect macro on activation the sheet and call removeoneselected on leave the sheet.

The macro is working wonderful on using qlikview desktop. However the same macro is not working when I use it qlikview server and access it on access point through my browser

I have allowed system acces on qlikview desktop and allows unsafe macro execution on server

Can someone please help me how to fix this

Syed

Re: issue when running a macro

jerrysvensson — Wed, 22 May 2013 07:47:18 GMT

Sheet triggers only works when you use plugin as client.

Using Ajax client it will not work, have a look at triggers in the reference manual.

Re: issue when running a macro

marcus_sommer — Wed, 22 May 2013 08:16:59 GMT

Possibly it works with a variable / several variables as trigger (OnChange):

varSheet = if(GetActiveSheetId() = 'SH01', 'select', 'deselect')

- Marcus

topic Re: issue when running a macro in QlikView

issue when running a macro

Re: issue when running a macro

Re: issue when running a macro