Expression meaning

[qlikviewwizard]

What is the meaning of the below expression meaning?

=year(today())-$1

Thanks in advance.

[robert_mika]

is this full expression?

Where are you using it?

[qlikviewwizard]

Hi Robert_Mika,

This is full expression. This was used in a variable.

[robert_mika]

Does it work?

Because with this syntax it will throw error

[qlikviewwizard]

Hi Robert_Mika,

Yes. This is used in an existing application.

[robert_mika]

What's the result ?

[qlikviewwizard]

Just it is showing '-'.

[Anonymous · Accepted solution]

Looks like a variable with parameter.  If you have a variable vYear defined as

year(today())-$1 

You can use it in a text box

=$(vYear(5))

and it will return 2010

Edit: see attached

[#9]

Hi

This is an expression. First part of the expression = year(today()) will give the current year.

Second pert $1 is variable with parameter. before use that first you have to create variable.

ex : eyear = year(today()) - $1

Please check the example I found :

eDeparturePerformed_VarUnit = Sum(# Departure Performed ) / 1$

1. 1st Expression - No of Flight will be = $(eDeparturePerformed_VarUnit (1))

2. 2nd Expression - No of Flights ( Thousand ) = $(eDeparturePerformed_VarUnit (1000))

2. 3rd Expression - No of Flights ( Millions ) = $(eDeparturePerformed_VarUnit (1000000))

[qlikviewwizard]

Hi mov,

Thank you so much.