topic Re: Macro's are not working on Access Point(AJAX) in QlikView

Macro's are not working on Access Point(AJAX)

Tue, 11 Dec 2012 11:03:46 GMT

Hi all;

I created 3 macro's YTD,QTD&MTD, when i select in application those are working but when i selected in access point(AJAX) those macro's are not working.can any one advice me how to solve it.

I used this code in macro's edit module

sub YTD

ActiveDocument.GetSheetObject("CH121").Activate

ActiveDocument.GetSheetObject("CH122").Activate

end sub;

.......etc........

I checked Allow unsafe macro's on server.

Thanks,

Ashok.

Re: Macro's are not working on Access Point(AJAX)

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 11:05:15 GMT

Hi,

Some macros do not work in Ajax, and that is the expected behavior. What events are you using to trigger those macros? A button, an action, when you change a value in a field?

Regards.

Miguel

Re: Macro's are not working on Access Point(AJAX)

Tue, 11 Dec 2012 11:14:55 GMT

Hi Miguel,

I used button & action is "Run macro".

Re: Macro's are not working on Access Point(AJAX)

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 11:19:01 GMT

Hi,

Use conditionals based on a variable value instead. For example, the button sets a variable named "vYTD" to 1 when clicked. The charts have a conditional like

vYTD = 1

so they are only displayed when you click on the button. Check an example app here. This will work in Ajax and you prevent using macros.

Hope that helps.

Miguel

Re: Macro's are not working on Access Point(AJAX)

Tue, 11 Dec 2012 12:09:01 GMT

Hi,

But actuvally if i select YTD button then it shows 1-bar chart & 1-stright tabe as comparing last 3 years means i used 3 expressions in YTD.

like that QTD&MTD also then how.

Re: Macro's are not working on Access Point(AJAX)

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 12:15:59 GMT

Hi,

What if you click on the QTD button first? Does it work and the rest of buttons quit working? You are just activating objects and not modifying expressions, aren't you? If all charts are in the same sheet, then I'd insist on the use of variables and conditional visibility instead. If they are in different sheets, you will need to first activate the sheet where the charts are.

Not having the QVW makes difficult to guess the layout and functionality.

Miguel

Re: Macro's are not working on Access Point(AJAX)

Wed, 12 Dec 2012 06:18:33 GMT

Hi,

I used that set variable method but that is suitable for only two butttons but i need 3 buttons.

i used like this

variable: V=1

YTD Button:

Button - action - Set Variable ->v

Value:

=If(v = 1, 2, 1)

Text:

=if(v=1,'YTD','YTD')

In chart, use v variable in Layut-conditional - show = v=1

QTD Button:

Button - action - Set Variable ->v

Value:

=If(v = 1, 2, 1)

Text:

=if(v=2,'QTD','QTD')

In chart, use v variable in Layut-conditional - show = v=2

How do i create MTD Button?

Set variable taking two values true/false.