Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mathematical Calculation

Hi community,

How to do mathematical calculation to the input box variable using some other variable values.where we need to do this

please help me on this

Thanks

5 Replies
israrkhan
Specialist II
Specialist II

hi i did not get you properly, where do you want these calculation,

but generally you can calculate the input variable with other fields or variable like below

if i put this in text object it working...

=$(ExchangeRate) * $(vYear) + Year + sum(Sales).

where

1) ExchangeRate is my input variable.

2) vYear is a max Year

3) Year is db field

4) sum(Sales) is expression.

Not applicable
Author

Hi,

I want calculated value should be shown in input box variable

israrkhan
Specialist II
Specialist II

YES YOU CAN DO THAT,

create 3 variable

a= 25

b= 50

c= =$(a)+ $(b)

create an input box, select c for field... you will see 75 in input box...

see the attached

is it???

Not applicable
Author

Hi,

Not like this

I have 2 input boxes ,i want the calculation in second input box depends on first input box value 

israrkhan
Specialist II
Specialist II

I have 2 input boxes ,i want the calculation in second input box depends on first input box value .......

what is dependency in first input box, and did not you get any idea from previous attachment..

cant you attached a sample, or explain in detail,