Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How to make my raw data value display as 2 digit decimal

Hi All

I have a field = S_Price

From the link i get the below load script to get 2 decimal.      http://community.qlik.com/thread/90550


     num(trim(S_Price),' #,##0.00') as LIST_PRICE_,

Above load script i am able to make the raw data display 2 decimal point,.

     S_Price/1.4 as LIST_PRICE

Now i need to convert the S_Price from US to SGD currency by divide by 1.4

May i know how to make it display 2 decimal point ?

Paul

1 Solution

Accepted Solutions

Re: How to make my raw data value display as 2 digit decimal

Hi,

     try this.

     

     round(LIST_PRICE,0.01)

Regards,

Kaushik Solanki

3 Replies

Re: How to make my raw data value display as 2 digit decimal

Hi,

     try this.

     

     round(LIST_PRICE,0.01)

Regards,

Kaushik Solanki

Not applicable

Re: How to make my raw data value display as 2 digit decimal

Hi Kau

Thank you for your sharing , notice that your not work , after play around , i found below does work :-

     num(trim(S_Price)/1.4,' #,##0.00') as LIST_PRICE

Paul

Not applicable

Re: How to make my raw data value display as 2 digit decimal

Hi Kau

I am sorry ,after put my code into test , i notice your code work , mine is not work.

Paul

Community Browser