Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

How to make it return with out decimal point ?

Hi All

I use below expression :-

money(

sum(sales/Rate)

,$#,##0)

it return with 2 decimal point.

May i know how to make it return with decimal point ?

Paul

1 Solution

Accepted Solutions
tresesco
Not applicable

Re: How to make it return with out decimal point ?

Is this a typo? Did you put quotes around the format like?

money( sum(sales/Rate) ,'$#,##0')

3 Replies
tresesco
Not applicable

Re: How to make it return with out decimal point ?

Is this a typo? Did you put quotes around the format like?

money( sum(sales/Rate) ,'$#,##0')

kamal_sanguri
Not applicable

Re: How to make it return with out decimal point ?

Try this

=money(sum(sales/Rate),'$#,##0','.',',')

paulyeo11
Not applicable

Re: How to make it return with out decimal point ?

Hi All

Thank you very much , all work.

Paul Yeo