Converting from text to number

[#1]

Dear,

How can I convert from text to number?

I've tryied to use the function Num#(fildname) but it dit not worked.

My problem is:

I have 2 columns in my excel spreadsheet, each one with values from 0 up to 100.

The values can be 0, 4, 5, 7, 99.. I mean, it is a random field!

And I would like to plot column A x Column B.

But the problem is that the chart is not showing empty values, and I´m seeing that the axes are like text and not numbers.

For example, one of my values is 02, but it is the same thing as if it were 2.

The chart is showing 0 - 02 - 3

And the distance between 0 - 02 - 3 is the same of the 80 - 100. Coz there is no value between 80 and 100

Did you get it?

Check the picture

How can I solve it?

Thanks per your attention,

Best regards

[alexandros17 · Accepted solution]

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.

when you compute the product do num(field1) * num(field2)

Hope it helps

[#3]

Hello,

Thaks per your fast response!

It worked, but the chart's axes steps are not the same.

I would like to have a chart with the following values at the X and Y axes:

0 - 10 - 20 - 30 ...90 - 100

I mean, the step should be 10.

And I´ve already seted it up at the axes tab of chart properties

And check how it is now!

Thank you so much per your attention,

Best regards

[alexandros17]

Step by 10 is not so easy, if you need it let me know ... in the meanwhile could you mark my answer?

Thanks

[#5]

Ok, you answer was marked!

I really need the step!

How can I fix?

[alexandros17]

You have to decide at first:

1) you want all the products but the two axis show only values 10 by 10

2) you want values to be grouped at 10, 20 and so on ... in this way you must decide how!

In the first case, there must be a property in the axis option that set it (I haven't qlikview installed on this computer but I'll let you know tomorrow morning)

[#7]

I don´t need the values grouped at 10, 20...

I just need the axes at the same size...

The way it is now, it is not proportional and can let me to a wrong conclusion!

I´ve already tried to set it up at the property > Axes, but it didn´t worked!

Check the picture

Thanks again per your attention

[alexandros17]

I'm really sorry, but I couldn't find a way to show what you need ... probably it's not possible