topic Re: Converting from text to number in QlikView

Converting from text to number

Thu, 21 Feb 2013 19:27:30 GMT

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

Re: Converting from text to number

alexandros17 — Thu, 21 Feb 2013 19:38:37 GMT

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

Thu, 21 Feb 2013 19:48:26 GMT

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

Re: Converting from text to number

alexandros17 — Thu, 21 Feb 2013 19:56:22 GMT

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

Thu, 21 Feb 2013 19:59:45 GMT

Ok, you answer was marked!

I really need the step!

How can I fix?

Re: Converting from text to number

alexandros17 — Thu, 21 Feb 2013 20:07:58 GMT

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

Thu, 21 Feb 2013 20:14:35 GMT

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

Re: Converting from text to number

alexandros17 — Fri, 22 Feb 2013 08:04:29 GMT

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