topic Amount format in QlikView

Amount format

qlikviewaf — Mon, 04 Sep 2017 10:13:50 GMT

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 — Mon, 04 Sep 2017 10:20:28 GMT

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 — Mon, 04 Sep 2017 10:47:00 GMT

Hii,

Instead of changing DecimalSep in script you can try this

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

its_anandrjs — Mon, 04 Sep 2017 11:40:41 GMT

Can you share your excel file.

antoniotiman — Mon, 04 Sep 2017 12:11:33 GMT

Hi Antonio,

try this

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

Regards,

Antonio