Adding text to fields in if condition

[asinghal0412]

Dear Qlik Community,

I have a code below:

=if([Calendar Year]= year(today()),[Calendar Year/Month])

which gives the solution:

Jan 2021

Feb 2021

Mar 2021

Apr 2021

May 2021

Jun 2021

Jul 2021

Aug 2021

Sep 2021

Oct 2021

Nov 2021

Dec 2021

I want to write a code to give below as a solution

Jan 2021 Actual

Feb 2021 Actual

Mar 2021 Actual

Apr 2021 Actual

May 2021 Actual

Jun 2021 Actual

Jul 2021 Actual

Aug 2021 Actual

Sep 2021 Actual

Oct 2021 Actual

Nov 2021 Actual

Dec 2021 Actual

I tried the code below but it does not work

=if([Calendar Year]= year(today()),[Calendar Year/Month]+'Actual')

Can anyone share how to achieve this goal?

Thanks,

Akash

[GaryGiles · Accepted solution]

You need to use & instead of + for text.

=if([Calendar Year]= year(today()),[Calendar Year/Month]&'Actual')

[MayilVahanan · Accepted solution]

HI @asinghal0412 

For concatenate the string, you need to use "&" symbol in Qlik

=if([Calendar Year]= year(today()),[Calendar Year/Month] & ' Actual')