Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
soha1902
Creator
Creator

Money format issue

Hi All,

I have amount data in this format:

Amountqvw.png

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

3 Replies
dilipranjith
Partner
Partner

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
Creator III
Creator III

settu_periasamy

Hi,

Try this in script

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