topic Re: How do i convert the value KG to Ton in QlikView

How do i convert the value KG to Ton

Thu, 28 Jun 2012 11:40:34 GMT

Dear All

I have a small query in my data, i need to convert the value KG to Ton.

loa_Rate

16000.25

27325.00

27.25

60.00

There are some values which are in KG(RED color) that i want to convert in to Ton.i mean multiplying by 1000. How do i that ?

output will be

16000.25

27325.00

27000.25

60000.00

Can any one help me.

Regards,

Nirmal.

Re: How do i convert the value KG to Ton

jonathandienst — Thu, 28 Jun 2012 11:49:17 GMT

Nirmal

Something like this perhaps (replace ... with the rest oof the load statement)

LOAD ...

If(Ioa_Rate < 1000, Ioa_Rate*1000, Ioa_Rate) As Ioa_Rate,

FROM ...

Not sure how you decide whether the value is Kg or ton.

Hope that helps

Jonathan

BTW I assume that you meant to convert 27.25 from tons to kg to get 27250kg?

Re: How do i convert the value KG to Ton

deepakk — Thu, 28 Jun 2012 11:53:15 GMT

hi Nirmal,

I think you need another which tell us that the current row is in KG or Ton. Is there any possibilty that you can add another field which says Kg or ton like below

loa_Rate Unit

16000.25 ton

27325.00 ton

27.25 Kg

60.00 Kg

using the unit we can create another field as below.

if(unit ='Kg',loa_Rate*1000,loa_Rate) as New_LoaRate

I don't think using the color option you can identify its kg or ton.

Deepak

Re: How do i convert the value KG to Ton

Thu, 28 Jun 2012 11:55:40 GMT

Dear Jonathan,

Thanks, Its working..

Regards,

Nirmal.

Re: How do i convert the value KG to Ton

Thu, 28 Jun 2012 11:57:18 GMT

Hi Deepak,

We dont have such type of field in Data.

Regards,

Nirmal/Napo