Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Insert Comma

Hi,

 

1)How to insert a comma in value?

IP: 35825 op:35,825

ip:3281564 op:3,281,564

2) How to replace the value -7.8 to (7.8)?

 

Kindly suggest.

Labels (1)
  • v7.x

1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@Learner2512 ,

1) if you were generating the output as file you can set the thousand separator in the advanced settings>>Advanced separator (for numbers) of tFileOutputDelimmited.

2) row2.newColumn.replaceAll("-","") 

 

View solution in original post

1 Reply
manodwhb
Champion II
Champion II

@Learner2512 ,

1) if you were generating the output as file you can set the thousand separator in the advanced settings>>Advanced separator (for numbers) of tFileOutputDelimmited.

2) row2.newColumn.replaceAll("-","")