topic Re: Concatenate String in a variable in QlikView

Concatenate String in a variable

Tue, 05 Aug 2014 10:06:08 GMT

Hello,

There is my problem:

i just wanna create a string with all the month name (like"JanuFebrMarcApri...")

How can i do this?

This is what i tried:

for mois=01 to 12

let TestVar = $(TestVar)&$(=left(MonthName('0000-'&num($(mois), 00)&'-01'),4));

next mois

I get a Syntax Error and I don't know where i'm doing a mistake.

Thanks,

Regards,

Loïc

Re: Concatenate String in a variable

tresB — Tue, 05 Aug 2014 10:11:10 GMT

Try like(Front end):

=Concat(Distinct(Month(MakeDate(1,mois,1)) )

Re: Concatenate String in a variable

MK_QSL — Tue, 05 Aug 2014 10:18:31 GMT

Load Replace('$(MonthNames)',';','') as Months AutoGenerate 1;

Re: Concatenate String in a variable

Tue, 05 Aug 2014 11:45:37 GMT

Hello,

The value of my variable TestVar is always <NULL> with:

for mois=01 to 12

let TestVar = Concat(Distinct(Month(MakeDate(1,mois,1)) ));

next mois

Re: Concatenate String in a variable

MK_QSL — Tue, 05 Aug 2014 12:19:53 GMT

Use my method without any loop or for loop

Re: Concatenate String in a variable

Tue, 05 Aug 2014 12:40:06 GMT

Thanks but i want to get all the passed months of the current year in the string.

Your way to do this works but i get all the months.

For example, today the string would be 'JanvFévMarsAvrilMaiJuinJuil'

Re: Concatenate String in a variable

MK_QSL — Tue, 05 Aug 2014 12:48:11 GMT

Temp:

Load

RowNo() as NO,

SubField('$(MonthNames)',';',(Month(YearStart(Today())) + IterNo() - 1)) as MinMonth

AutoGenerate 1

While Month(YearStart(Today())) + IterNo() - 1 <= Month(Today());

Load Concat(MinMonth,',',NO) as AllMonths Resident Temp;

Re: Concatenate String in a variable

MarcoWedel — Wed, 06 Aug 2014 00:45:14 GMT

Hi Loïc,

maybe also helpful:

using this expression:

=PurgeChar(If(Month(Today())<12,Left(MonthNames,Index(MonthNames, ';', Month(Today()))-1),MonthNames),';')

for month names like

regards

Marco