now - script and chart function

This function returns a timestamp of the current time. The function returns values in the TimeStamp system variable format. The default timer_mode value is 1.

Syntax:

now([ timer_mode])

Return data type: dual

The now() function can be used either in the load script or in chart objects.

Arguments
Argument	Description
timer_mode	Can have the following values: 0 (time at last finished data load) 1 (time at function call) 2 (time when the app was opened) Information noteIf you use the function in a data load script, timer_mode=0 will result in the time of the last finished data load, while timer_mode=1 will give the time of the function call in the current data load.

When to use it

The now() function is commonly used as a component within an expression. For example, it can be used to calculate the time remaining in a product's lifecycle. The now() function would be used instead of the today() function when the expression requires the use of a fraction of a day.

The following table provides an explanation of the result returned by the now() function, given different values for the timer_mode argument:

Function examples
timer_mode value	Result if used in load script	Result if used in chart object
0	Returns a timestamp, in the TimeStamp system variable format, of the last successful data reload prior to the latest data reload.	Returns a timestamp, in the TimeStamp system variable format, for the latest data reload.
1	Returns a timestamp, in the TimeStamp system variable format, for the latest data reload.	Returns a timestamp, in the TimeStamp system variable format, of the function call.
2	Returns a timestamp, in the TimeStamp system variable format, for when the user’s session in the application began. This will not be updated unless the user reloads the script.	Returns the timestamp, in the TimeStamp system variable format, for when the user’s session in the application began. This will be refreshed once a new session begins or the data in the application is reloaded.

Regional settings

Unless otherwise specified, the examples in this topic use the following date format: MM/DD/YYYY. The date format is specified in the SET DateFormat statement in your data load script. The default date formatting may be different in your system, due to your regional settings and other factors. You can change the formats in the examples below to suit your requirements. Or you can change the formats in your load script to match these examples.

Default regional settings in apps are based on the regional system settings of the computer or server where Qlik Sense is installed. If the Qlik Sense server you are accessing is set to Sweden, the Data load editor will use Swedish regional settings for dates, time, and currency. These regional format settings are not related to the language displayed in the Qlik Sense user interface. Qlik Sense will be displayed in the same language as the browser you are using.

Example 1 – Generation of objects using load script

Overview

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

This example creates three variables using the now() function. Each variable uses one of the timer_mode options to demonstrate their effect.

For the variables to demonstrate their purpose, reload the script and then, after a short period of time, reload the script a second time. This will result in the now(0) and now(1) variables showing different values, thereby correctly demonstrating their purpose.

Load script

LET vPreviousDataLoad = now(0);
LET vCurrentDataLoad = now(1);
LET vApplicationOpened = now(2);

Results

Once the data has been loaded for a second time, create three textboxes using the directions below.

First, create a textbox for the data which has previously been loaded.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure to the object:

=vPreviousDataLoad
Under Appearance, select Show titles and add the title 'Previous Reload Time' to the object.

Next, create a textbox for the data which is currently being loaded.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure to the object:

=vCurrentDataLoad
Under Appearance, select Show titles and add the title 'Current Reload Time' to the object.

Create a final textbox to show when the user's session in the application was started.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure to the object:

=vApplicationOpened
Under Appearance, select Show titles and add the title 'User Session Started' to the object.

Diagram showing what each of the three generated textboxes could look like after using the now() function to load the variables via the load script. — now() load script variables

The above image shows example values for each of the created variables. For example, the values could be as follows:

Previous Reload Time: 6/22/2022 8:54:03 AM
Current Reload Time: 6/22/2022 9:02:08 AM
User Session Began: 6/22/2022 8:40:40 AM

Example 2 – Generation of objects without load script

Overview

In this example, you will create three chart objects using the now() function, without loading any variables or data into the application. Each chart object uses one of the timer_mode options to demonstrate their effect.

There is no load script for this example.

Do the following:

Open the Data load editor.
Without changing the existing load script, click Load data.
After a short period of time, load the script a second time.

Results

Once the data has been loaded for a second time, create three textboxes.

First, create a textbox for the latest data reload.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure:

=now(0)
Under Appearance, select Show titles and add the title 'Latest Data Reload' to the object.

Next, create a textbox to show the current time.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure:

=now(1)
Under Appearance, select Show titles and add the title 'Current Time' to the object.

Create a final textbox to show when the user's session in the application was started.

Do the following:

Using the Text & Image chart object, create a textbox.
Add the following measure:

=now(2)
Under Appearance, select Show titles and add the title 'User Session Began' to the object.

Diagram showing what each of the three generated textboxes could look like after using the now() function to create chart objects only, with no data loaded into the application. — now() chart object examples

The above image shows example values for each of the created objects. For example, the values could be as follows:

Latest Data Reload: 6/22/2022 9:02:08 AM
Current Time: 6/22/2022 9:25:16 AM
User Session Began: 6/22/2022 8:40:40 AM

The 'Latest Data Reload' chart object uses a timer_mode value of 0. This returns the timestamp for the last time the data was successfully reloaded.

The 'Current Time' chart object uses a timer_mode value of 1. This returns the current time according to the system clock. If the sheet or object is refreshed, this value will be updated.

The 'User Session Began' chart object uses a timer_mode value of 2. This returns the timestamp for when the application was opened, and the user’s session began.

Example 3 – Scenario

Overview

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

The load script contains:

A dataset consisting of inventory for a cryptocurrency mining operation, which is loaded into a table called Inventory.
Data with the following fields: id, purchase_date, and wph (watts per hour).

The user would like a table that displays, by id, the total cost each mining rig has incurred in the month so far, in terms of power consumption.

This value should update whenever the chart object is refreshed. The current cost of electricity is $0.0678 per kWH.

Load script

SET DateFormat='MM/DD/YYYY';

Inventory:
Load
*
Inline 
[
id,purchase_date,wph
8188,1/7/2022,1123
8189,1/19/2022,1432
8190,2/28/2022,1227
8191,2/5/2022,1322
8192,3/16/2022,1273
8193,4/1/2022,1123
8194,5/7/2022,1342
8195,5/16/2022,2342
8196,6/15/2022,1231
8197,6/26/2022,1231
8198,7/9/2022,1123
8199,7/22/2022,1212
8200,7/23/2022,1223
8201,7/27/2022,1232
8202,8/2/2022,1232
8203,8/8/2022,1211
8204,8/19/2022,1243
8205,9/26/2022,1322
8206,10/14/2022,1133
8207,10/29/2022,1231
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension: id.

Create the following measure:

=(now(1)-monthstart(now(1)))*24*wph/1000*0.0678

If the chart object was refreshed at 6/22/2022 10:39:05 AM, it would return the following results:

Results table
id	=(now(1)-monthstart(now(1)))24wph/1000*0.0678
8188	$39.18
8189	$49.97
8190	$42.81
8191	$46.13
8192	$44.42
8193	$39.18
8194	$46.83
8195	$81.72
8196	$42.95
8197	$42.95
8198	$39.18
8199	$42.29
8200	$42.67
8201	$42.99
8202	$42.99
8203	$42.25
8204	$43.37
8205	$46.13
8206	$39.53

The user would like the object results to refresh every time the object is refreshed. Therefore, the timer_mode argument of supplied for instances of the now() function in the expression. The timestamp for the start of the month, identified by using the now() function as the timestamp argument in the monthstart() function, is subtracted from the current time which is identified by the now() function. This provides the total amount of time that has elapsed so far this month, in days.

This value is multiplied by 24 (the number of hours in a day) and then by the value in the wph field.

To convert from watts per hour to kilowatts per hour, the result is divided by 1000 before finally being multiplied by the kWH rate supplied.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here