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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II
‎2023-03-07 10:50 PM

I want to display only the first 13 data.

Now I want R_WORK_LOT to display only the first 13 characters, how do I do that?

Paknanarn23_0-1678247415557.png

 

570 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2023-03-08 12:35 AM

Hi

You can try with Left function

Left(R_WORK_DT, 13) as First13CharRWORKDT

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

547 Views
1 Reply
MayilVahanan
MVP
MVP
‎2023-03-08 12:35 AM

Hi

You can try with Left function

Left(R_WORK_DT, 13) as First13CharRWORKDT

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
548 Views
Community Browser