Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

Thanks per your attention,

Best regards

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

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

View solution in original post

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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!

Help2.JPG

Thank you so much per your attention,

Best regards

alexandros17
Partner - Champion III
Partner - Champion III

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

Thanks

Not applicable
Author

Ok, you answer was marked!

I really need the step!

How can I fix?

alexandros17
Partner - Champion III
Partner - Champion III

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)

Not applicable
Author

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

Help3.JPG

Thanks again per your attention

alexandros17
Partner - Champion III
Partner - Champion III

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