Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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