topic Re: Using text box value in an expression in another text box in QlikView

Using text box value in an expression in another text box

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

Hello.

I am trying to write an if statement in a text box using a value from another text box. Is this possible, and if so, how can I do this?

Re: Using text box value in an expression in another text box

vishsaggi — Thu, 24 May 2018 19:14:56 GMT

Can you show an example of what exactly you are doing? Where you having issue? You can just use the same expr in your other textbox using IF(yourexprfromother textobject, ...., ....) somthing like this.

However, why don't you use variable to store this first textobject expr and use this variable in your 2nd textobject.

Can you also provide your exact requirement please?

Re: Using text box value in an expression in another text box

Anil_Babu_Samineni — Fri, 25 May 2018 02:50:09 GMT

You can create your Variable base on that you can calculate in second object. For example,

You have variable called Variable1 = Sum(Sales)

And second object you call it as If($(Variable1)>100, 'More than 100', 'Else')

Re: Using text box value in an expression in another text box

Anonymous — Fri, 25 May 2018 04:37:10 GMT

you could easily reference it with variables than directly accessing text values from another textbox