Right - script and chart function

Right() returns a string consisting of the last (rightmost) characters of the input string, where the number of characters is determined by the second argument.

Syntax:

Right(text, count)

Return data type: string

Arguments:

Arguments
Argument	Description
text	The original string.
count	Defines the number of characters to be included from the rightmost part of the string text.

Example	Result
Right('abcdef', 3)	Returns 'def'

T1:
Load 
*, 
right(Text,Start) as Right;        
Load * inline [
Text, Start
'abcdef', 3
'2021-07-14', 4
'2021-07-14', 2
];

Result

Qlik Sense table showing the output from using the Right function in the load script.
Text	Start	Right
abcdef	3	def
2021-07-14	4	7-14
2021-07-14	2	14

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