Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a application field and its release field and every release has its own version.
where the versions are of 1.4 and 1.40 values .
in database these versions have values as above .
but when i load it in qlikview it is showing both the values as 1.40.
Can anyone please let me know how to resolve this.
Thanks in advance.
Anjee
Hi,
The Text() is the good thing to do (I've expected the same issue with code starting with 0).
Maybe can you try to force into your excel sheet the format of your cell to be text and not number?
Regards,
Vincent
If QlikView interprets 1.40 and 1.4 as numbers, then they are identical and will be treated as one and the same value. Changing formatting - either with the Num() function or the Numbers tab - will not change this.
If you want QlikView to treat the two as different values, you need to load them using the Text() function.
HIC
HI Henric,
Thanks for the reply.
I tried using the Text(version) also.but then also it is giving all the converted values as same.
I have attached the source and output in the above query.
Thanks,
Anjee
Hi
Are you loading from a database table, text file or Excel?
If database - what is the type of the field? It should be a char/text type, not a number type. If it is a number type, ODBC /OLEDB is returning a number, so the 0 will be lost before it gets to QV, and text(Field) will return 1.4.
If Excel - is the value numeric (right aligned) or string (left aligned)? If it is numeric, again the 0 will again be lost before it gets to QV and Text(Field) will return 1.4
If the data source is delivering text "1.40", then Text(Field) will return "1.40".
HTH
Jonathan
Hi
I am loading the data from the data base (ODBC).
Fieldname is VERSION,
Datatype is varchar(50).
Thanks,
Anjee
Try this
Select
'V-'+VERSION as VERSION
FROM Your table
in your load from QDBC source this should force QlikView to save it as text
Then you can manipulate it back to 1.4 or 1.40 using subfield() function