Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)