# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Creator III

## Concatenate variable and string in set analysis

Hi

so my variable vBVvirtuo has 2014 in it.

I'd like to be concatenated with -12 to give 2014-12 that would be the value set in my set analysis for the field année-période financière.

This is what I had in mind:

sum({1<[Année-période financière]= {'\$(=vBVvirtuo)&'-12''}>} [Montant cumulé aad])

What am I screwing up?

1 Solution

Accepted Solutions
Creator III
Author

Hi all,

first off, I didn't need to do a make date, but I did have to create another variable.

vBVvirtuoMM = \$(vBVvirtuo)&'-12'

and in my set analysis:

sum({1<[Année-période financière]= {'\$(=vBVvirtuoMM)'}>} [Montant cumulé aad])

that worked.

thanks to both of you.

3 Replies
Not applicable

vValue = Makedate(vBVvirtuo,12,1)

or

vValue = Date(Makedate(vBVvirtuo,12,1),'YYYY-MM')

Then use this value depending on [Année-période financière] values.

Thanks

Employee

sum({1<[Année-période financière]= {'\$(=vBVvirtuo&'-12')'}>} [Montant cumulé aad])

Creator III
Author

Hi all,

first off, I didn't need to do a make date, but I did have to create another variable.

vBVvirtuoMM = \$(vBVvirtuo)&'-12'

and in my set analysis:

sum({1<[Année-période financière]= {'\$(=vBVvirtuoMM)'}>} [Montant cumulé aad])

that worked.

thanks to both of you.