Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String to number

hey guys,

i have a simple problem, but i haven't come to a conclusion yet.
After having loaded an excel sheet, qlikview displays my numbers as strings.
I have tried using any kind of num function in the script, but it doesn't work.
I just need the numbers, without decimals.

Sorry, but I'm a total Qlikview newb 🙂

thanks a lot!

error loading image

2 Replies
Not applicable
Author

Go chart properties and then go number tab click on integer.

Regards

Ashish Srivastava

Not applicable
Author

Hi,

You need not apply any function.

Go to chart properties-Number

Select you dimension and tick "Fixed to".

Make no. of decimals zero.

It will answer your queries.

Happy Thoughts