Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I have a data with values like: 0,5, 0,69 and so on.
Qlikview doesnt recognize these values like numbers, so I need to convert them. I try like num#(Values,'#,##') and it convert values like 0,69 into numbers, however, leaving numbers like 0,5 as text.
And when i try num#(Values,'#,#') it convert 0,5in numbers and leaves 0,5 as text.
Any suggestions on how I can convert all the values into numbers?
You can use num(fieldname) ...
format numbers as follows num(fieldname,'00') on order to show all values like 01 or 04 and so on.
Hi Diana,
num#(Values,'#,#', ',') should work for you, you'll need to set the decimal separator also
hope that helps
Joe
Hi, Joe!
Unfortunately, it isn't working
Try:
REPLACE(Value, ',', '.') AS Value
Hi,
use num#(Value,'#,00#')
Regards
This worked perfectly great!
Thank YOU!!!
Hi Diana,
Two ways you can try for this solution
1) Goto Number Tab in chart properties , from there u can change
2) num(num#()) you can use
Hi..
Joe Simmons
I want some real time scenario and examples with expressions.
Please Help Me.
Thanks,
Srinu
Hi
working good
Thanks