Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my display from xxxx.xxx to xxxx ?

Hi All

May i know how to modify the below expression , so that it will return with out dwcimal point. I expected it display 194. Now it display 193.68607618441

=(month*30*Avg({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (STK_OPEN+STK_CLOSE)/2))

/(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS_+COGS_INT_)/1))

+

(month*30*Avg({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (AR_CLOSE+AR_OPEN)/2))

/sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (REVENUE+REVENUE_INT_)/1)

-

-1*(month*30*Avg({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (AP_CLOSE+AP_OPEN)/2))

/sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS_+COGS_INT_))

1 Solution

Accepted Solutions
mov
Employee
Employee

Just use round():

round(<your long expression here>)

View solution in original post

3 Replies
mov
Employee
Employee

Just use round():

round(<your long expression here>)

MK_QSL
MVP
MVP

Use

Num(YourExpression,'#0')

paulyeo11
Master
Master
Author

Hi Michael

Thank , it work.

Paul