topic Re: Concatenate variable and string in set analysis in QlikView

Concatenate variable and string in set analysis

sibrulotte — Mon, 18 Aug 2014 19:25:23 GMT

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?

Mon, 18 Aug 2014 19:41:31 GMT

Please create another variable like

vValue = Makedate(vBVvirtuo,12,1)

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

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

Thanks

JonnyPoole — Mon, 18 Aug 2014 19:46:29 GMT

how about this ?

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

sibrulotte — Mon, 18 Aug 2014 19:52:41 GMT

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.