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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ceil funtion

i have value in decimal points like 2.3567890 and i want to show rounded value like 2.357, so guide me how  i use ceil function to achive result

Labels (1)
2 Replies
teempi
Partner - Creator II
Partner - Creator II

Hi zain,

Ceil(2.3567890, 0.001) should do the trick

-Teemu

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Many ways you can achieve it

     Num(2.3567890, 0.000)

     Round(2.3567890, 0.001)

     Ceil(2.3567890, 0.001)

Hope it helps

Celambarasan