Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i'm quite new in qlik sense and i'v a problem that may be simple to solve, but confused me.
I need to cut a string and then use the remaining numbers to make a calculation. Here is my code:
=num#(left('1.96534 GB',len('1.96534 GB')-3))*1024
Were '1.96534 GB' is a sample of my collumn value.
Doesn't matter what i do it always return '-' (null i guess).
What am i doing wrong?
Hi ! The problem is the decimal separator.
Perhaps this isn't the best solution, but it works fine if your decimal sep is ',' :
=Replace( left('1.96534 GB', len('1.96534 GB')-3), '.', ',') * 1024
Regards, Fernando
Hi ! The problem is the decimal separator.
Perhaps this isn't the best solution, but it works fine if your decimal sep is ',' :
=Replace( left('1.96534 GB', len('1.96534 GB')-3), '.', ',') * 1024
Regards, Fernando