topic Re: Set actions via Macro in QlikView

Set actions via Macro

5abi0001 — Wed, 28 Feb 2018 10:54:33 GMT

Hey! Via a macro i create textboxes. Now what i want to do is, to set also certain actions for this created textboxes like on click on the textbox it should set a value for a variable or run a macro. Is it possible to give the textbox such instructions?

Re: Set actions via Macro

tamilarasu — Thu, 01 Mar 2018 02:11:05 GMT

Macro Action:

Sub Test  
  
 set MyText = ActiveDocument.ActiveSheet.CreateTextObject 
 set prop = MyText.GetProperties  
 set TextActions = prop.Layout.ActionItems  
 TextActions.Add  
 TextActions.Item(0).Type=13   
  
 set ActionParam=TextActions.Item(0).Parameters 
 ActionParam.Add  
 ActionParam.Item(0).v="Test"  
 MyText.SetProperties prop  
  
End Sub

Variable Action:

Sub Test

Set MyText = ActiveDocument.ActiveSheet.CreateTextObject
set prop = MyText.GetProperties
set TextActions = prop.Layout.ActionItems
TextActions.Add
TextActions.Item(0).Type=31

set ActionParam=TextActions.Item(0).Parameters
ActionParam.Add
ActionParam.Item(0).v="Test"
ActionParam.Add
ActionParam.Item(1).v="0"
MyText.SetProperties prop 

End Sub

Re: Set actions via Macro

5abi0001 — Thu, 01 Mar 2018 09:05:55 GMT

Hey! Thank you this is exact this, what im looking for. How i can add this two actions within a sub? tamilarasu‌

Re: Set actions via Macro

tamilarasu — Fri, 02 Mar 2018 05:24:31 GMT

Hi Prince,

Here is the code.

Sub Test
 
set MyText = ActiveDocument.ActiveSheet.CreateTextObject 
 set prop = MyText.GetProperties    
 set TextActions = prop.Layout.ActionItems    
 
 TextActions.Add    
 TextActions.Item(0).Type=13 
 
 set ActionParam=TextActions.Item(0).Parameters 
 ActionParam.Add    
 ActionParam.Item(0).v="Macro_Test"
 
''''MyText.SetProperties prop   
 
 TextActions.Add  
 TextActions.Item(1).Type=31 
 
 set ActionParam= TextActions.Item(1).Parameters  
 ActionParam.Add   
 ActionParam.Item(0).v= "Variable_Test"  
 ActionParam.Add    
 ActionParam.Item(1).v="0"
 
 MyText.SetProperties prop 
 
End Sub

Re: Set actions via Macro

5abi0001 — Fri, 02 Mar 2018 08:43:18 GMT

Thank you! U are the best!

Re: Set actions via Macro

tamilarasu — Fri, 02 Mar 2018 09:12:28 GMT

Have a nice day and happy weekend, Prince.