QlikView Solutions

Monday, December 4, 2017

Removing Preceding Zero from any filed in QLikview

Requirement is to remove leading zeros from field values of Numnber. This is a text field and can contain numeric or alpha-numeric values.
The trick I could do is:


=replace(ltrim(replace(Field,'0',' ')),' ','0')



Posted by SHIV DUTT SHROTRIYA at 3:23 AM 2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

My photo
SHIV DUTT SHROTRIYA
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  September (1)
  • ►  2018 (2)
    • ►  February (2)
  • ▼  2017 (11)
    • ▼  December (1)
      • Removing Preceding Zero from any filed in QLikview
    • ►  September (2)
    • ►  April (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (3)
  • ►  2016 (14)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  August (7)
    • ►  May (2)
    • ►  April (1)
Simple theme. Theme images by gaffera. Powered by Blogger.