Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

negative value in bracket

Hi All,

i have a sample data like below

Tab:

Load * Inline [


Name,Produt,sales

raju,A,100

siva,B,200

yannie,C,-300

anu,D,-600

venkat,E,500]

;




so i want in front end   if the value is in negative  it should show in ()  if value is possitive  normal number it can show   [Stright table]


example:   -300   means   (300)



Thanks

Sony

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Sony,

You can do it two ways,

Capture.PNG

                                                                                       Or

Capture1.PNG

Output:

Capture.PNG

View solution in original post

1 Reply
tamilarasu
Champion
Champion

Hi Sony,

You can do it two ways,

Capture.PNG

                                                                                       Or

Capture1.PNG

Output:

Capture.PNG