topic Re: Money format issue in QlikView

Money format issue

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sat, 23 Feb 2019 13:34:11 GMT

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 — Sat, 23 Feb 2019 18:42:15 GMT

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

settu_periasamy — Sat, 23 Feb 2019 18:55:09 GMT

Hi,

Try this in script

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