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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

number formatting....showing upto two places after decimal

hi

i am facing a situtation in which i have to show upto two values after decimal for a particular row in a pivot table....

if i use num('a','#.#')

it will display all the values after decimal. how can i restrict it to two values only.....

e.g 134.57

1 Reply
Not applicable
Author

try this num(FIELDNAME, '###.#0')