Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklearnervir
Creator
Creator

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
sunny_talwar

swuehl
MVP
MVP

Try

Text(Phone_Number)          as [Phone number]