Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II

substring in Load Script

hello im looking for an alternatif solution for the syntaxe on SQL substring('ITM_REF',1,2) in ('15') is this possible on load script as a condition ?

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

You can use Mid(), refer below link

 

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

You can use Mid(), refer below link

 

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.