Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
alwinsch
Contributor

Use of Variables in expressions

  Hi all,

I put my formula in a Variable (Vcomm).

call the result of the variable in a textbox $(Vcomm) ---> this give me a correct result

call another variable (Vgrowth) which stores the value 3%

 

Now I want another textbox that gives me the Vcomm + 3% growth.
I do this as follows: $(Vcomm) * (1+ Vgrowth)

it does not give me an exact calculation. The result is not the Vcomm + 3%

What am I doing wrong?

Kind regards,
A
lwin

 

 

 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Use of Variables in expressions

Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies

Re: Use of Variables in expressions

What does it give you?

MVP & Luminary
MVP & Luminary

Re: Use of Variables in expressions

Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.


talk is cheap, supply exceeds demand

View solution in original post

alwinsch
Contributor

Re: Use of Variables in expressions

thanks,

I converted it to numeric and that did the trick.