LongMonthNames

Overview

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

The load script contains:

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

• A date field.

• The default LongMonthNames definition.

Load script

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; 
						
Transactions: 
Load 
date, 
Date(date,’MMMM’) 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 LongMonthNames definition is used. In the load script, to create a field called, month, the Date function is used with the date field as the first argument. The second argument in the function is the formatting MMMM.

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

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 LongMonthNames variable that is modified to use the abbreviated days of the week in Spanish.

Load script

SET LongMonthNames='Enero;Febrero;Marzo;Abril;Mayo;Junio;Julio;Agosto;Septiembre;OctubreNoviembre;Diciembre'; 

Transactions: 
LOAD 
date, 
Date(date,'MMMM') as monthname, 
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 sum(amount) as a measure and these fields as dimensions:

• date

• monthname

Create this measure:

=sum(amount)

In the load script, the LongMonthNames variable is modified to list the months of the year in Spanish. Then, to create a field called, monthname, theDate function is used with the date field as the first argument. The second argument in the function is the formatting MMMM.

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