Textbox Expression as Variable

[#1]

Hi All,

I have a textbox which has an expression to bring back the results of an expression,

Is there anyway to use that result in another expression? I have searched through the threads and seen GetFieldValue() but nothing seems to work.

If it is a lost cause, what alternatives do people use?

Thanks Again

Toby

[#2]

Post up an example if you can

[#3]

Hi Joe

Example would be that I have a text box which produces a value of 10.

I then want to reference that result of 10 in another expression.

Is this possible?

Toby

[Anonymous · Accepted solution]

Toby

If your expression was

    today()

Then you could set that as an expression :

    set vToday = today() ;

And display it in a Text Box using a dollar expansion :

    = $(vToday)

And in a second Text Box reuse the dollar expansion and add 22 days to it :

    =date (  $(vToday) +  22 )

See mock up qvw attached.

[awhitfield]

HI Toby,

sorry if I have misunderstood, but can't you just incorporate the text box expression elsewhere? Or use the text box expression results stored as a variable?

Andy

[#6]

Hi Andrew

The storing as variable thing I think is the answer but being new I am still learning the ropes (I have Business Objects background)

Toby

[#7]

Thanks Bill I have had a quick play but either the Friday fatigue or stupidity but where do you declare the expression?

Mine is

count({<DateRaisedIMS={"=Year(DateRaisedIMS) = year(Today())"},ValueID={'*24*'}, IncidentType={'*Accident*'}, ListTitle={'*Employee*'}>}ValueID)

[#8]

Just worked this out so thank you Bill!!! You are a legend!

[awhitfield]

Glad you managed to sort it! Have a good one 

Andy

[#10]

Thanks Andy and thanks for taking the time to answer my question

Have a great weekend.

Toby