topic Re: Convert Size of Building in the script in QlikView

Convert Size of Building in the script

alec1982 — Mon, 20 Aug 2012 16:08:08 GMT

Hi,

I have a table that hold Building ID, Size and Size Type.

Some Ids are typed in SF and some other are typed in Hectares and others are SQ.m.

How can I get the right size for all of them in SF

Like could I do IF sizeType = Sq.m. then Size * Factor1

If Size Type = hectares then Size * Factor2

if size Type = SF then Size *1

end as Size SF

Thxs,

Alec

Re: Convert Size of Building in the script

manojkvrajan — Mon, 20 Aug 2012 17:19:15 GMT

You can do that in many different ways. However, my suggestion is to incorporate the following logic with an additional field if you are very sure about displaying the values in SF. Please make sure you have the righ conversion logic factor in place. I hope this helps.

Factor 1 = 10.76

Factor 2 = 107639.10416709722

Table:

LOAD

[Building ID],

[Size Type],

IF([Size Type] = 'Sq.m',[Size]*10.76,

IF([Size Type] = 'Hectares',[Size]*107639.10416709722, Size)) AS Size

FROM

xyz.qvd;

Re: Convert Size of Building in the script

alec1982 — Mon, 20 Aug 2012 17:49:46 GMT

Thank you so much!

Re: Convert Size of Building in the script

alec1982 — Mon, 20 Aug 2012 19:48:14 GMT

Somehow the Sq.m is not working..

I have double checked everything and I dont know why it is not working.!

Re: Convert Size of Building in the script

manojkvrajan — Mon, 20 Aug 2012 20:09:47 GMT

Please share me a sample data file and qvw to work.

Re: Convert Size of Building in the script

alec1982 — Mon, 20 Aug 2012 20:56:00 GMT

My bad!

it is working perfectly!

Thank you