topic Re: Issue with Comma in String in QlikView

Issue with Comma in String

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

My code is working fine in QlikView but whenever am trying to save the values into xls,csv its giving me wrong o/p

My Current O/P:

90,513,213,422,491,200

My Expected O/P:

9051321342,2491233

In QlikView its showing as 9051321342,2491233 but whenever trying to save this in xls,csv format O/P gets changed I have tried to convert the value into text but no use if its a Single Mobile Number then No issue if multiple Contacts are there then issue occur?

Regards,

Re: Issue with Comma in String

passionate — Tue, 06 Feb 2018 14:56:42 GMT

Set the format of column in Qlikview to whatever expected

like num(Cloumn,'##########,#######')

Re: Issue with Comma in String

m_woolf — Tue, 06 Feb 2018 14:59:50 GMT

Try opening the .csv in notepad or Notepad++ to see if the data is correct in the file.

Excel may be formatting the data when you open the file.

Re: Issue with Comma in String

Karim_Khan — Tue, 06 Feb 2018 15:01:12 GMT

Issue is coming while storing it into xls.if I will use ur logic i will convert all values into comma separated