topic Variable for current year? in QlikView

Variable for current year?

Mon, 26 Mar 2012 05:57:02 GMT

Hi All,

can anyone help me in variable,i am having ycode=2012 in my applications now i want to create a variable and i want to call that variable in instead of 2012.

where i want to create that variable and how to wright that variable for current year.example ycode displays the current year records from the adatabase.

Variable for current year?

SunilChauhan — Mon, 26 Mar 2012 05:59:25 GMT

ctrl +alt+v

add -> variable name

ex:

var1=max(ycode)

take a text box and wrte

=$(var1) it will show you 2012

hope this helps

Variable for current year?

Mon, 26 Mar 2012 06:03:55 GMT

Heelo sunil,

thanks for reply,..

i forgot to post for current month variable which they wrote in applications.i.e.,

LET CURRENT_MONTH = IF(NUM(MONTH(NUM(TODAY())))>3,NUM(MONTH(NUM(TODAY())))-3,NUM(MONTH(NUM(TODAY())))+9);

and also tell me it would be work in 2013 and soon..

regards,

bar

Variable for current year?

SunilChauhan — Mon, 26 Mar 2012 06:30:11 GMT

it will work

it is created for financial month.

Variable for current year?

Mon, 26 Mar 2012 07:33:20 GMT

Hello Sunil,

happy to your reply,

but still some confussion, actually what happen is i am having 20 company codes like 'Y'.they wrote year=2012 in every company in script level.now the current month is 12,after this month, mar-2012 is 13 like this wrote some sql quary.

now i want to write some variable in script insted of 2012(year=2012).i am writing some variables but it is not showing correctly.this will work after financial year end also.

Regards,

bar

Variable for current year?

Mon, 26 Mar 2012 12:15:01 GMT

Hello All,

Can anyone helpme in this issue.i created variable current_year=max(field name_year),but i used this variable in edit script level that is in Raw application.it displaying table not found.some sql error.

anyone know how to create variable for current year insted of 2012 or any other ways todo.

Regards,