Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
shamsu_mk
Creator
Creator

Text box formula

Dear team

I have two questions.

1) How can I link two separate text box with formula? Example : - Textbox A has a value of 3000 and Textbox B has a value of 7000. I need a formula in Textbox C to get the difference between two textboxes (7000-3000.)

2) In Textbox D i need the % of the variance

Please help

6 Replies
Chanty4u
MVP
MVP

what is that two expressions in two text box?

=Exp1-Exp2

vipin_mishra479
Creator II
Creator II

You can wright

in Text Box C = (Text box A expression ) - (Text box B expression )

in Text Box D =( (Text box A expression ) / (Text box B expression ))-1

Hope this will help you !!

shamsu_mk
Creator
Creator
Author

Presently I did in this way only. I thought there will be an easy way like we do in table like Coloumn 1 -Coloumn 2

shamsu_mk
Creator
Creator
Author

Yes, I did in this way. But I don't know the format to get the sign %

Chanty4u
MVP
MVP

create two variables  for that expressions and use like below

=(vTextbox1) - (vTextbox2)

vipin_mishra479
Creator II
Creator II

use

num (Value,'#,##0.0%')