topic Concatenate month and year variable in QlikView

Concatenate month and year variable

Wed, 21 May 2014 10:03:23 GMT

Hi, I have a column 'Month' which contains the month names and another variable 'year' which contains years 'YYYY'. How do I concatenate these 2 variables? Thanks.

Re: Concatenate month and year variable

Wed, 21 May 2014 10:09:53 GMT

you can concatenate two fields

Month &'/'& Year as MonthYear

Thanks

Padma

Re: Concatenate month and year variable

Wed, 21 May 2014 10:10:28 GMT

Hi Rachel,

If you have two variables do this:

LET NewVariable = $(MonthVariable) & $(YearVariable);

But if you want to concatenate values stored in one table column (Month) whith one variable you must do it into the script using this into the LOAD:

FieldName & VariableName as NewFieldName

Month & vYear as MonthYear

Let me know if you need more details.

Regards.

Re: Concatenate month and year variable

Anonymous — Wed, 21 May 2014 10:14:24 GMT

I hope you have created a master calendar and you can add the below code

This will create a field called MonthYear automatically

Date(Monthstart(TempDate),'MMM-YYYY') as MonthYear,

Re: Concatenate month and year variable

its_anandrjs — Wed, 21 May 2014 10:18:45 GMT

1. if they are two fields then use it like

Load

Month&'-'&Year as NewField

From Location;

2. And if they are variables then use it like

Let vNewVariable = $(vMonthVar)&'-'&$(vYearVar)

3. if Year is variable and month is field then

Load

Month&'-'&'$(vMonthVar)' as NewField

From Location;