Assigning a value to a variable from a sheet object

ali_hijazi — Thu, 19 May 2011 08:12:32 GMT

Hello

I'm new to QlickView

I'm using the following in my script

LET

vToday = makedate(2010,08,30) ;

LET

vCurrentYear = Year (vToday) ;

is there a way to LET vCurrentYear take a value from the selected item of a list box holding all available years?

erichshiino — Thu, 19 May 2011 12:57:48 GMT

Yes,

Then you don't need to define it on the script.

You can go to setting-> Variable overview and create it there.

then the expression on the variable can be: (if your field is YEAR)

=YEAR

=ONLY(YEAR)

-> They work is the user can select only one year.

Other possibility is:

=max(YEAR) -> to get the max of the selected years

=max( {1} YEAR) -> to get max year independently of selection

=year(today()) -> to get the year considering the computer's calendar.

Hope it helps,

Erich

topic Assigning a value to a variable from a sheet object in QlikView