topic Re: Expression meaning in QlikView

Expression meaning

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

What is the meaning of the below expression meaning?

=year(today())-$1

Thanks in advance.

Re: Expression meaning

robert_mika — Wed, 24 Jun 2015 01:13:35 GMT

is this full expression?

Where are you using it?

Re: Expression meaning

qlikviewwizard — Wed, 24 Jun 2015 01:17:17 GMT

Hi Robert_Mika,

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

Re: Expression meaning

robert_mika — Wed, 24 Jun 2015 01:19:55 GMT

Does it work?

Because with this syntax it will throw error

Re: Expression meaning

qlikviewwizard — Wed, 24 Jun 2015 01:24:36 GMT

Hi Robert_Mika,

Yes. This is used in an existing application.

Re: Expression meaning

robert_mika — Wed, 24 Jun 2015 01:30:30 GMT

What's the result ?

Re: Expression meaning

qlikviewwizard — Wed, 24 Jun 2015 01:39:07 GMT

Just it is showing '-'.

Re: Expression meaning

Anonymous — Wed, 24 Jun 2015 01:44:27 GMT

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

Re: Expression meaning

Wed, 24 Jun 2015 01:55:49 GMT

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))

Re: Expression meaning

qlikviewwizard — Wed, 24 Jun 2015 01:59:01 GMT

Hi mov,

Thank you so much.

Re: Expression meaning

qlikviewwizard — Wed, 24 Jun 2015 02:02:52 GMT

Hi Prasadhet,

Thank you for the answer.