Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Labeling of fields

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

1 Solution

Accepted Solutions
ashfaq_haseeb

Hi,

Try like this

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

Regards

ASHFAQ

View solution in original post

9 Replies
ashfaq_haseeb

Hi,

Try like this

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

Regards

ASHFAQ

View solution in original post

morganaaron
Specialist
Specialist

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

maxgro
MVP
MVP

add ()

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

Not applicable
Author

hi,

use it

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

Regards

Vimlesh

fvelascog72
Partner
Partner

Maybe you want this:

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

Anonymous
Not applicable
Author

workaround does the job (in my case)

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

Not applicable
Author

Hi all

Thanks for your help!

morganaaron
Specialist
Specialist

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!

rubenmarin

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.