Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Can I reference value of a text object in a formula?

Is it possible to reference the value of a text object in a formula?

I have two text objects that display percentages. I also need to display the difference between the two percentages.

Is is possible to refer to the value in the text object directly (e.g Difference = Text1.Value - Text2.Value) or will I need to write out the formula including the formula for both the text objects (e.g Difference = (entire formula for calculating Text1) - (entire formula for calculating Text2) )?

I only ask because I will need to repeat this kind of thing many times in the dashboard.

Any help or ideas would be greatly appreciated

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Can I reference value of a text object in a formula?

No you can't refer like that directly. Alternatively you can think of using variables to hold the expression value and use that variable as and when needed.

View solution in original post

3 Replies
Not applicable

Re: Can I reference value of a text object in a formula?

Hi,

Please try this: Difference = GetFieldValue(Text 1) - GetFieldValue(Text 2).

MVP
MVP

Re: Can I reference value of a text object in a formula?

No you can't refer like that directly. Alternatively you can think of using variables to hold the expression value and use that variable as and when needed.

View solution in original post

Not applicable

Re: Can I reference value of a text object in a formula?

Thanks, I thought that might be the case