Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (3)
1 Solution

Accepted Solutions

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

7 Replies

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

Not applicable

Re: Converting from text to number

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

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

Not applicable

Re: Converting from text to number

Ok, you answer was marked!

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)

Not applicable

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

Help3.JPG

Thanks again per your attention

Re: Converting from text to number

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

Community Browser