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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.