MonthNames

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset of dates that is loaded into a table named Transactions.

• A date field.

• The default MonthNames definition.

Load script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; 

Transactions: 
LOAD 
date, 
Month(date) as monthname, 
id, 
amount 
INLINE  
[ 
date,id,amount 
01/01/2022,1,1000.45 
01/02/2022,2,2123.34 
01/03/2022,3,4124.35 
01/04/2022,4,2431.36 
01/05/2022,5,4787.78
01/06/2022,6,2431.84 
01/07/2022,7,2854.83 
01/08/2022,8,3554.28 
01/09/2022,9,3756.17 
01/10/2022,10,3454.35 
]; 

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• date

• monthname

Create this measure:

=sum(amount)

The default MonthNames definition is used. In the load script, the Month function is used with the date field as the provided argument.

In the results table, the output of this Month function displays the months of the year in the format of the MonthNames definition.

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset of dates that is loaded into a table named Transactions.

• A date field.

• The MonthNames variable that is modified to use the abbreviated months in Spanish.

Load script

Set MonthNames='Enero;Feb;Marzo;Abr;Mayo;Jun;Jul;Agosto;Set;Oct;Nov;Dic'; 

Transactions: 
LOAD 
date, 
month(date) as month, 
id, 
amount 
INLINE  
[ 
date,id,amount 
01/01/2022,1,1000 
02/01/2022,2,2123 
03/01/2022,3,4124 
04/01/2022,4,2431 
]; 

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• date

• monthname

Create this measure:

=sum(amount)

In the load script, first the MonthNames variable is modified to list the months of the year abbreviated in Spanish. The Month function is used with the date field as the provided argument.

In the results table, the output of this Month function displays the months of the year in the format of the MonthNames definition.

It is important to remember that if the language for the MonthNames variable is modified like it has been in this example, the LongMonthNames variable would still contain the months of the year in English. The LongMonthNames variable would have to be modified if both variables are used in the application.

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset of dates that is loaded into a table named Transactions.

• A date field.

• The default MonthNames definition.

Load script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; 

Transactions: 
LOAD 
date, 
Month(date, ’MMM’) as monthname, 
id, 
amount 
INLINE  
[ 
date,id,amount 
01/01/2022,1,1000.45 
01/02/2022,2,2123.34 
01/03/2022,3,4124.35 
01/04/2022,4,2431.36 
01/05/2022,5,4787.78 
01/06/2022,6,2431.84 
01/07/2022,7,2854.83 
01/08/2022,8,3554.28 
01/09/2022,9,3756.17 
01/10/2022,10,3454.35 
]; 

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• date

• monthname

Create this measure:

=sum(amount)

The default MonthNames definition is used. In the load script, the Date function is used with the date field as the first argument. The second argument is MMM.

Using this formatting Qlik Sense converts the values from the first argument into the corresponding month name set in the variable MonthNames. In the results table, the field values of our created field month display this.