Data format

[#1]

Hi all,

If i have a mix of percentage and integer values in a column,Qlikview converts all of them into percentage after reloading the data.

Can this be avoided since i want the original data.

For example:

Metrics     Minimum Service Level

A              99.90%
B              89

C              678

D              80.00%
E              67

After Reloading i get:

Metrics     Minimum Service Level

A              99.90%
B              8900.00%

C              67800.00%

D              80.00%
E              6700.00%

Why is it happening?Can anyone help?

[senpradip007]

Are you using any function? I have tried with the sample data which is working fine.

[its_anandrjs]

Provide your load script or sample file.

[kaushiknsolanki]

Hi,

     You can convert the values in text and then again convert them into number or percentage. Something like below.

     DATA:

     Load Metric,Text(MSL) as MSL from xyz;

     DATA1:

     Load Metric as METRIC, if(wildmatch(MSL,'%'),MSL,num#(MSL)) as NEW)MSL

     Resident DATA;

Drop table DATA;

Regards,

Kaushik Solanki