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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

working with decimal in script

I have following script which will output PI amount in excel file ,  how to round up into 2 decimal Pi amount

Concatenate(Export)

LOAD

'PI Amount' as 'Category',

[ Code] as G1,

     [Destination] as D1,

     [ Type] as T,

     [Departure Month] as TM,

     [ Fee] as Amount

Resident Header Where  IsrarH= 'T' AND

[Departure Date] >= $(vStartdate) and [ Departure Date] <= $(vEnddate)

1 Reply
isingh30
Specialist
Specialist

To Round to two decimal places, you would use Round(field, '0.01').

See page 393 of Book I in the Reference Manual.


Thanks.