Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

Straight table, remove decimal

HI  i have a amount in dollar and cents . how to remove cents value and also $ sign.

for eg  $316.25     i only want 316

1 Solution

Accepted Solutions
sunny_talwar

Go to the number's tab and change the format from $#,##0.00 to $#,##0

or if you are using a num function for the format, then change the format there

View solution in original post

1 Reply
sunny_talwar

Go to the number's tab and change the format from $#,##0.00 to $#,##0

or if you are using a num function for the format, then change the format there