Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bruno_silva100
Contributor III
Contributor III

Concat Title with 2 variable

When I use 2 variable in the title, it doesn't appear, but when i use only 1 variable appears.

='Comparativo - ' &  $(vMaiorAno)  & '/' & $(vMaiorAno)-1 = Error

='Comparativo - ' &  $(vMaiorAno)  & $(vMaiorAno)-1 = Error

='Comparativo - ' &  $(vMaiorAno) = ok

Labels (1)
1 Solution

Accepted Solutions
bruno_silva100
Contributor III
Contributor III
Author

The solution is parentheses after the 3rd &

'& (max ([Year Emission]) - 1)'

='Comparativo ' & max([Ano Emissão]) & '-' & (max([Ano Emissão])-1)

 

View solution in original post

8 Replies
Channa
Specialist III
Specialist III

='Comparativo - ' &  $(vMaiorAno)& $(vMaiorAno)

 

why u using -1

Channa
bruno_silva100
Contributor III
Contributor III
Author

because I want to do the comparation with past year

jwjackso
Specialist III
Specialist III

Try

='Comparativo - $(vMaiorAno)  /' & ($(vMaiorAno)-1)

Channa
Specialist III
Specialist III

=vMaiorAno&vMaiorAno-1

Channa
bruno_silva100
Contributor III
Contributor III
Author

result = Comparativo - Max(Ano)/2018
bruno_silva100
Contributor III
Contributor III
Author

not working
dplr-rn
Partner - Master III
Partner - Master III

did you try
Comparativo - ' & $(vMaiorAno) & '/' & ($(vMaiorAno)-1 )

or

Comparativo - ' & $(vMaiorAno) & '/' & (Num($(vMaiorAno))-1 )

bruno_silva100
Contributor III
Contributor III
Author

The solution is parentheses after the 3rd &

'& (max ([Year Emission]) - 1)'

='Comparativo ' & max([Ano Emissão]) & '-' & (max([Ano Emissão])-1)