Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Setting how numbers are displayed from raw load

I am trying to get a huge list of sales documents to display in a format that is easy to identify, basically the issue is caused because the first two characters of every number is not needed. how do I remove them?

Example:

Raw

001234

001432

008633

005678

009878

Desired format

1234

1432

8633

5678

9878

Thanks and best regards,

Alex.

1 Reply
m_woolf
Master II
Master II

num#(Raw) as Desired