Numeric variable with 100% density - not all values show

[#1]

I have a numeric variable that shows as 100% density.  The data is read in as a csv file and is fully populated, however when I create a list box of this variable, a high proportion (circa 85%) of the values are missing.

Has any got any ideas why this would be happening?

[#2]

Maybe an issue with the decimal symbol. Check if the data are with a comma or a dot, then go to the script and change the setting if it isn't correct.

JJ

[#3]

Thanks for the response.

I have no format on the numbers being read in, there is no decimal point or comma.

Just realized the numbers not showing are being read in like : 3.42E+08

Do you know how to read in as normal numbers?

Thanks

lee

From: Jean-Jacques Jesua

Sent: 25 January 2012 19:34

To: lee davies

Subject: - Re: Numeric variable with 100% density - not all values show

QlikCommunity <http://community.qlik.com/index.jspa>

Re: Numeric variable with 100% density - not all values show

created by Jean-Jacques Jesua <http://community.qlik.com/people/vanheflin> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/185638#185638

[Anonymous]

Hi Lee,

You can see this post:

http://community.qlik.com/message/107994#107994

Dilyana

[#5]

Hi,

Thanks, Id tried this but it did nt seem to work.

The field is called pol_ref_c

So I coded:

Load

pol_refc,

Num(Left(pol_refc, Index(pol_refc, 'E') -1) * Pow(10, TextBetween(pol_refc, 'E+', ''))) AS pol_refc_num

I get “-“ in my new field pol_refc_num

Is my coding correct?

Regards

Lee

From: Dilyana_CVL

Sent: 26 January 2012 10:25

To: lee davies

Subject: - Re: Numeric variable with 100% density - not all values show

QlikCommunity <http://community.qlik.com/index.jspa>

Re: Numeric variable with 100% density - not all values show

created by Dilyana_CVL <http://community.qlik.com/people/dilyana_cvl> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/185714#185714