topic Re: Textbox Expression as Variable in QlikView

Textbox Expression as Variable

Fri, 15 May 2015 12:30:31 GMT

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

Re: Textbox Expression as Variable

Fri, 15 May 2015 12:32:43 GMT

Post up an example if you can

Re: Textbox Expression as Variable

Fri, 15 May 2015 12:36:35 GMT

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

Re: Textbox Expression as Variable

Anonymous — Fri, 15 May 2015 12:45:45 GMT

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.

Re: Textbox Expression as Variable

awhitfield — Fri, 15 May 2015 12:46:07 GMT

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

Re: Textbox Expression as Variable

Fri, 15 May 2015 12:50:45 GMT

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

Re: Textbox Expression as Variable

Fri, 15 May 2015 12:53:16 GMT

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)

Re: Textbox Expression as Variable

Fri, 15 May 2015 12:57:05 GMT

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

Re: Textbox Expression as Variable

awhitfield — Fri, 15 May 2015 13:15:06 GMT

Glad you managed to sort it! Have a good one

Andy

Re: Textbox Expression as Variable

Fri, 15 May 2015 13:18:46 GMT

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

Have a great weekend.

Toby