topic Re: Macro not working in QlikView

Macro not working

Thu, 29 May 2014 11:42:45 GMT

Dear Experts,

i have created a straight table with 4 dimensions and four Expressions (Revenue,projected Revenue, Difference) revenue is Straight forward coming to Projected revenue is copy of Revenue. but when i use what if scenario using input box on Projected Revenue the values are not reflecting

set theInputBoxValue = ActiveDocument.GetVariable("var_InputBox")

set FieldToModify = ActiveDocument.Fields("ProjectedSales_modified")--->projected Revenue

Re: Macro not working

fkeuroglian — Thu, 29 May 2014 12:22:53 GMT

Hi, please can you put an example for us

it will be easier to help you

Fernando

Re: Macro not working

Thu, 29 May 2014 12:40:13 GMT

hi fernando,

suppose if Projected revenue is 2000 in straight table when i apply what-if analysis and i gave you the value 20% on the input box it should calculate projected revenue 2400 please guide me how to achieve this using macro..

Re: Re: Macro not working

fkeuroglian — Thu, 29 May 2014 12:53:49 GMT

Hi, you don not have to use macro to have what you are looking

see this example

hope this help

Fernando

Re: Macro not working

Thu, 29 May 2014 13:39:22 GMT

hi fernad the file what you are given is showing the below error

"the license embedded in this document is not valid"