Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jaweher89
Contributor III
Contributor III

Mixed type column

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You might want to change during load, like:

Load

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

View solution in original post

5 Replies
tresesco
MVP
MVP

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.

jaweher89
Contributor III
Contributor III
Author

How could I display the number in proper way?

stig1984
Creator II
Creator II

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.

girishsrini
Partner
Partner

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.

tresesco
MVP
MVP

You might want to change during load, like:

Load

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

View solution in original post