Skip to main content

Qlik

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: 
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

 

271 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

248 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.
249 Views