Discussion Board for collaboration related to QlikView App Development.
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.
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
or use money(money#(yourField,'£#,##0','',','))
Try this in script
Num#(Amount,'£#') as Amount