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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mid function in the script

Anyone knows why the Mid function in the script does not work.

It said the Mid function is not the build-in function.

Please help.

Thanks

Labels (1)
3 Replies
Not applicable
Author

You can use MID function in the script:


mid(FieldName,StartNum,EndNum) as NewFieldValue;
Mid(MonthName,1,3) as Month_Name;


Verify this as an answer once you check.

Femke
Contributor III
Contributor III

Hi, 

I had the same issue. Try to shut your previous load with ' ; '. For me that helped. 

Kind regards 

Chanty4u
MVP
MVP