topic Re: Mixed type column in QlikView

Mixed type column

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a column that can contain number or characters(Mixed type). I don't understand why I get this value? Any explanation please?

Re: Mixed type column

tresB — Tue, 30 Jan 2018 12:41:36 GMT

This itself is a number and not text. 'E' stands for exponent here. When a number is very large or very small, the number is represented in scientific notation (e). Search the web for more details.

Re: Mixed type column

Anonymous — Tue, 30 Jan 2018 12:43:15 GMT

How could I display the number in proper way?

Re: Mixed type column

stig1984 — Tue, 30 Jan 2018 12:47:48 GMT

Change the number format for that field to either integer or fixed number of decimal places on the NUMBER tab of the report properties, or use the NUM function as veerendrakatikala suggests.

Re: Mixed type column

girishsrini — Tue, 30 Jan 2018 12:50:48 GMT

Hi,

Can you please send the screenshot of values from the column you are talking about. Unless text and number values are concatenated, shouldn't be problem for Totals.

Re: Mixed type column

tresB — Tue, 30 Jan 2018 12:58:47 GMT

You might want to change during load, like:

Load

Num(NumberField, '(dec)') as NewNum