calling a macro on click of back button

[qliksus]

Hi guys,

i have simple query how to call a macro on click of back button

[disqr_rm]

Not 100% solution but will surely give you some idea.

[disqr_rm]

I think I got it 100% now.... check the enclosed out.

And by any chance if you are looking for Trigger on Clear, here it is: http://community.qlik.com/forums/p/20552/78942.aspx#78942

[qliksus]

Hi rakesh,

i have checked ur file u are calling a macro on open and then u are creating another macro for clear .With out that macro also if u click the clear button the value will be cleared .I dont want such an option .What i am doing is i have created a macro as follows

sub MILSTON

if

activedocument.variables("a1").getcontent. string = "1" then

set

c = activedocument.fields("MILESTONE_TEST").GetSelectedValues

activedocument.fields (

"_Milestones_tests"). select c.item(0).text

else

activedocument.fields(

"MILESTONE_TEST"). select " "

end

end

sub

What the above macro will do is it will take the value in the column MILESTONE_TEST and select it in

_Milestones_tests .So now if click the back button then only the clolumn _Milestones_tests . will be cleared but i want both the columns to be cleared i.e (_Milestones_tests ,MILESTONE_TEST) on the single click of back button

[#5]

Rakesh,

I am having your QVW name as "EXPORT TO PPT".

I am having a similiar problem where i want data in excel instead of ppt after finishing reload of qvw.

Here my excel sheet name should be same everytime .

Can you help em to achieve this result because you are genious in dealing with macros.

This is an urgent requirement from my client.

Thanks in advance.........

Regards,

Qlik n Nicks

[#6]

Rakesh,

Can you pls send me any sample qvw which is using macro for "send to excel " option automatically at fixed time everyday.

Regards,

Qlik n Nicks