7 Replies Latest reply: Feb 22, 2013 3:04 AM by Alessandro Saccone

Converting from text to number

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?

Best regards

• Re: Converting from text to number

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

• Re: Converting from text to number

Hello,

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

• Re: Converting from text to number

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

Thanks

• Re: Converting from text to number

I really need the step!

How can I fix?

• Re: Converting from text to number

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)

• Re: Converting from text to number

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