Money format issue - Qlik Community

soha1902 · ‎2019-02-23

Hi All,

I have amount data in this format:

In this format I am not able to perform kind of aggregation function like sum(). Please help me on this.

dplr-rn · ‎2019-02-23

You data is being read as text not as a number.

either do changes in your source i.e. how excel is generated or

remove £ from the value in excel using

PurgeChar(Amount, '£') as Amount

mikaelsc · ‎2019-02-23

or use money(money#(yourField,'£#,##0','',','))

settu_periasamy · ‎2019-02-23

Hi,

Try this in script

Num#(Amount,'£#') as Amount