Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Macro not working

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Re: Macro not working

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

see this example

hope this help

Fernando

View solution in original post

4 Replies
Partner
Partner

Re: Macro not working

Hi, please can you put an example for us

it will be easier to help you

Fernando

Not applicable

Re: Macro not working

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..

Partner
Partner

Re: Re: Macro not working

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

see this example

hope this help

Fernando

View solution in original post

Not applicable

Re: Macro not working

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

"the license embedded in this document is not valid"