Money format issue

[soha1902]

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]

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]

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

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/In...

[settu_periasamy]

Hi,

Try this in script

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