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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kkarlste
Creator
Creator

skript number

Hi

Take all the numbers before the dash for example A51273-2
and then take all numbers after that this must show this 51273

 

Kalle

 

Labels (1)
1 Reply
sbaro_bd
Creator III
Creator III

Hi @kkarlste ,

Right(Subfield(Dimension,'-',1),5)

OR

Right(Subfield(Dimension,'-',1),Len(Subfield(Dimension,'-',1))-1)

Regards