topic Re: Another simpleton question: Turn nr. into str in QlikView

Another simpleton question: Turn nr. into str

datanibbler — Wed, 05 Feb 2014 08:36:19 GMT

Hi,

my issue is very simple: I have eight tables to CONCATENATE in the script. Seven of them have a nr. (the nr. of a delivery_slot, like "81, 82, 83" - one has a nr. and a text, "73-LV".

=> I have already enclosed them all in upper quotes, but still those seven are regarded as numbers and displayed on the right-hand side of a listbox, the eigth is regarded as text and displayed on the left.

=> How can I make them all the same (text)?

Thanks a lot!

Best regards,

DataNibbler

Re: Another simpleton question: Turn nr. into str

agilos_mla — Wed, 05 Feb 2014 08:38:42 GMT

Load Text([FieldName]) AS FieldName,

Or in the presentation tab of the list box, set the alignment on left/right for numbers and texts

Michael.

Re: Another simpleton question: Turn nr. into str

atsushi_saijo — Wed, 05 Feb 2014 08:44:01 GMT

Good morning. This is typecast and TEXT() is used to convert datatype into text. However; once typecasted, they are not read as number.

Re: Another simpleton question: Turn nr. into str

ashwanin — Wed, 05 Feb 2014 08:47:23 GMT

=text(field) as Field

in script

Re: Another simpleton question: Turn nr. into str

datanibbler — Wed, 05 Feb 2014 08:50:41 GMT

Hi,

thanks! The display on the left and right is, of course, only a symptom and not a big deal in itself - but there should not be this difference.

I'll use this function.

Best regards,

DataNibbler