Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliklearnervir
New Contributor III

how to convert 20 digit number in qlikview

Hi,

I have 18 to 20 digit phone number in below sub query :

SUB callrequest_f(ColumnDetails, KeyColumn)

  ColumnDetails = '

  batchjobid as [Batch Job ID]

  

      ,deleteflag as [Delete Flag]

  ,modifiedon_src as [Modified on Source]

  ,modifiedon_stg as [Modified on Staging]

  ,modifiedon_wh as [Modified on Warehouse]

  ,Phone_Number                                  as [Phone number]

      ;'

  KeyColumn = '[Call Request WID]';

END SUB

and i am getting phone number like  45675645+e15  ..

I want complete number .please suggest .

where to add cast function in the above sub queries.

2 Replies

Re: how to convert 20 digit number in qlikview

MVP
MVP

Re: how to convert 20 digit number in qlikview

Try

Text(Phone_Number)          as [Phone number]

Community Browser