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 at

2 comments:

  1. Alfred AvinaMarch 19, 2020 at 10:49 AM

    The main motive of the Big data implementation services is to spread the knowledge so that they can give more big data engineers to the world.

    ReplyDelete
  2. James ZicrovJuly 10, 2020 at 5:57 AM

    I feel Qlik is the best way of finding more and more solutions to some technical problems.This is always useful to crack more and more complex IT solutions.

    Qlik Soap API Connection

    ReplyDelete

Subscribe to: Post Comments (Atom)