Amount format

[qlikviewaf]

Hi Guys,

i imported in qlik this excel below, but when the amount is with deciamls is not imported since my script has DecimalSep= ','.

I want to keep decimal sep with comma, but how then i can import in the right way this field ?

Thank you

[Anil_Babu_Samineni]

You can try

This in script

Replace(EXTENDED_PRICE_AM, '.',',') as EXTENDED_PRICE_AM

OR In UI try like below

Num(Sum(EXTENDED_PRICE_AM), '#0.00')

[divya_shinde]

Hii,

Instead of changing DecimalSep in script you can try this

Find below screenshot you can give ', ' in format pattern

[its_anandrjs]

Can you share your excel file.

[antoniotiman]

Hi Antonio,

try this

Num(Num#(Field,'#','.',','))

Regards,

Antonio