Number Formatting

[anushahegde]

Hi all,

In my applicationthere is a field called version number. It is a combination of a major version and a minor version. For example, 1.1 represents “major version 1, minor version 1” and 1.10 represents “major version 1 and minor version 10”. Note that 1.1 and 1.10 are different versions. However, it appears that when the data is loaded into Qlik, version 1.10 is being loaded as 1.1.

I need 1.10 to load as 1.10 and  1.1 to still load as 1.1. How to achieve this?

Thanks in advance

Anusha

[zzyjordan · Accepted solution]

Hi, Anusha

When you load your data, you can convert the value of version as text, using Text() as shown below
Load Text("version") as version Inline [
version
1.1
1.10
];

Hope this helps

ZZ

[anushahegde]

Thanks a lot