Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

everest226
Contributor 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)

Tags (2)
1 Reply
isingh30
Contributor III

Re: working with decimal in script

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

See page 393 of Book I in the Reference Manual.


Thanks.

Community Browser