topic Text box formula in QlikView

Text box formula

shamsu_mk — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Text box formula

Chanty4u — Wed, 20 Jun 2018 05:38:55 GMT

what is that two expressions in two text box?

=Exp1-Exp2

Re: Text box formula

vipin_mishra479 — Wed, 20 Jun 2018 05:40:26 GMT

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

Re: Text box formula

shamsu_mk — Wed, 20 Jun 2018 06:42:47 GMT

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

Re: Text box formula

shamsu_mk — Wed, 20 Jun 2018 06:43:51 GMT

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

Re: Text box formula

Chanty4u — Wed, 20 Jun 2018 07:30:13 GMT

create two variables for that expressions and use like below

=(vTextbox1) - (vTextbox2)

Re: Text box formula

vipin_mishra479 — Wed, 20 Jun 2018 09:36:26 GMT

use

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