Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

negative values show in brackets

Hi All,

 

I have to show negative values in brackets in qlik sense pivot table, I have tried num function it doesn't work .

Num(MyCalc, '#,##0.00;(#,##0.00)')

 

Any help.

 

Thanks,

Sateesh.T

 

Labels (1)
2 Replies
mato32188
Specialist
Specialist

Hi Sateesh,

use Number formatting CUSTOM with #,##0.00;(#,##0.00) format pattern.

BR

Martin

 

ECG line chart is the most important visualization in your life.
sat_tok52
Creator
Creator
Author

Thanks Martin for your quick response.

 

It's working.