topic Re: Data format in QlikView

Data format

Wed, 07 May 2014 06:53:50 GMT

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 — Wed, 07 May 2014 07:03:20 GMT

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

its_anandrjs — Wed, 07 May 2014 07:07:14 GMT

Provide your load script or sample file.

kaushiknsolanki — Wed, 07 May 2014 07:07:28 GMT

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