topic Labeling of fields in QlikView

Labeling of fields

Tue, 31 Mar 2015 09:01:26 GMT

Hi all

I try to label a field with Actual and a via Formula generated Year

='Act ' & Year(Today())-1

but it doesn't work.

Can you help me with that?

Thanks in advance.

Oliver

Re: Labeling of fields

ashfaq_haseeb — Tue, 31 Mar 2015 09:03:49 GMT

Hi,

Try like this

='Act ' & Year(Today()-1)

Regards

ASHFAQ

Re: Labeling of fields

morganaaron — Tue, 31 Mar 2015 09:03:49 GMT

Wrap the Year(Today())-1 in brackets and it should!

Re: Labeling of fields

maxgro — Tue, 31 Mar 2015 09:04:09 GMT

add ()

='Act ' & (Year(Today())-1)

Re: Labeling of fields

Tue, 31 Mar 2015 09:05:05 GMT

hi,

use it

='Act ' & year(Today()-1)

Regards

Vimlesh

Re: Labeling of fields

fvelascog72 — Tue, 31 Mar 2015 09:05:05 GMT

Maybe you want this:

'Act'& (Year(Today())-1)

Re: Labeling of fields

Anonymous — Tue, 31 Mar 2015 09:06:09 GMT

workaround does the job (in my case)

='Act ' & max(year(today())-1) works

Re: Labeling of fields

Tue, 31 Mar 2015 09:07:12 GMT

Hi all

Thanks for your help!

Re: Labeling of fields

morganaaron — Tue, 31 Mar 2015 09:08:36 GMT

No worries - just a note, Ashfaq's answer will give you the year for yesterday - if you want the previous year for today, then use the formula given by myself and Massimo!

Re: Labeling of fields

rubenmarin — Tue, 31 Mar 2015 09:32:39 GMT

Massimo and Aaron were right, concatenation operator has the same priority as the addition operator, wich is in equal priority than the substraction operator, and the '&' used to concatenating is before the '-' used to substraction because in equal priority is evaluated left to right.

In example, if the expression was "='Act ' & Year(Today())*2" it will do first the multiplication and the concatenation (as multiplication has more priority than addition)

In that expression you need to add parentheses to specify to do first the substraction and then the concatenation.