Discussion Board for collaboration on QlikView Scripting.
I have Price coulmn in excel sheetas below:
I used trim(replace(Price),'$','') as Price1
Product Price My output expected o/p
A $10 10 10
B $20 20 20
C $15 15 15
D $-10 10 -10
E $-5 5 -5
F $25 25 25
G $-30 30 -30
Go to Solution.
Hi, Prashanth Reddy.
Num(PurgeChar(Price,'$')) as Price
P.S.: add expression of aggregation desired.
Hope this helps!
what format is your price_column in QlikView (not in Excel)?
If it's a STRING, you can use any of the STRING functions like SUBFIELD().
In excel I have in money format as I shown in Price column,
In qlik is getting like MyOutput column.
go to number format
And remove $ if you use Money
May be KeepChar()
Num#(KeepChar(Price, '0123456789-'), '#,##0.00;-#,##0.00') as Price
I am surprised you get any output from your expression. I have sorted your brackets, try this :
I tried it like this it is ok :
=trim(replace('$-10 ','$','') )
Num(Money#(Price, '$#,##0.00;-$#,##0.00')) as Price
I cannot use =trim(replace('$-10 ','$','') ) because i have so many records.
Hi Sunny, thanks for the reply,
Both are not working .