Discussion Board for collaboration related to QlikView App Development.
I have a strange result when loading date from a SQL database into qlikview.
In my database i have a field containing numbers and letters. It's a nvarchar column. When i import the data in qlikview, qlikview is adding somethimes '0' to that column in front of my data.
Does anybody know how to resolve that problem?
Your field CODEFAM is string field thats why you get 0 in front some values also this field has character and the numbers also so you are nor able to convert this into the number also. Try to make it text string like Text(CODEFAM).
Text(CODEFAM) as CODEFAM
How about using the isnum() function ?
You can test by putting these expression in a text box :
= if ( isnum( '01' ) , num ( '01' , '#0') , text ('01' ) )
= if ( isnum( 'L52' ) , num ( 'L52' , '#0') , text ('L52' ) )