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: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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: 
master_student
Creator III
Creator III
‎2017-03-08 05:29 AM

extract

Hello Guys,

Which Function in qlikview that allow me to extract a number from the 4th number and get 8 numbers

for example :

223698574

the result : 698574

Thanks

316 Views
0 Likes
1 Solution

Accepted Solutions
PrashantSangle
MVP
MVP
‎2017-03-08 05:31 AM

use mid()

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

249 Views
0 Likes
4 Replies
PrashantSangle
MVP
MVP
‎2017-03-08 05:31 AM

use mid()

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
250 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-03-08 05:32 AM

May be this?

Mid(FieldName, 4,8)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
249 Views
Not applicable
‎2017-03-08 05:32 AM

Hi

Mid (Field, 4, 😎 as NewField

Regards

249 Views
nitin_01
Creator
Creator
‎2017-03-08 05:35 AM

Hi WIEM,

Might this help you : =Mid('223698574',4)

as per you requirement you said

Regards,

Nitin.

249 Views