Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

want to add '-' to count the 6th data from the left.

I have a field 'Lot '

in field  'Lot ' contains data :

Sxbbb_0-1679643486797.png

 

want to add '-' to count the 6th data from the left.

EX

165052171

A0172050012

     

 

3 Replies
MarcoWedel

Where is the '-' sign in this example?

MarcoWedel_0-1679668160869.png

 

Sxbbb
Creator III
Creator III
Author

EX

165052-171

A0172050-012

MarcoWedel

How does  '-' "count the 6th data from the left" in these examples?