Making Qlikview view a field as a String and Not a Number

[#1]

Hi guys,

I have a table of values which has values 3.1, 3.2..........3.10. Therefore Qlikview is bunching both 3.1 and 3.10 as the same. I would like this to be treated as a string but Qlikview automatically assumes it to be a number and therefore groups both together. Is there a way to force this to be viewed as a string and not a number?

Regards,

[#2]

Hi,

try:

Text(YourField) as TextField

Good luck!

Rainer

[Anonymous]

Try Text(VariableName) as VariableName in your load script.