Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted

What does it give you?

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Creator
Creator

thanks,

I converted it to numeric and that did the trick.