Discussion board where members can get started with QlikView.
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.
you can concatenate two fields
Month &'/'& Year as MonthYear
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.
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,
1. if they are two fields then use it like
Month&'-'&Year as NewField
2. And if they are variables then use it like
Let vNewVariable = $(vMonthVar)&'-'&$(vYearVar)
3. if Year is variable and month is field then
Month&'-'&'$(vMonthVar)' as NewField