topic sum in QlikView

sum

deepakqlikview_123 — Wed, 11 Jun 2014 11:25:23 GMT

Hi All,

My data is in below format but I am not able to make sum for this.

Can you please suggest how to make sum for this.

Thanks,

Re: sum

senpradip007 — Wed, 11 Jun 2014 11:35:49 GMT

Try this:

Load

A,
SubField(B,' ',1) AS Size1,
SubField(B,' ',2) AS Unit1,
SubField(C,' ',1) AS Size2,
SubField(C,' ',2) AS Unit2,
B,
C
FROM
Book1.xlsx
(ooxml, no labels, table is Sheet1);

Re: sum

Wed, 11 Jun 2014 12:50:29 GMT

You posted an excel file with size logs? You want to sum the sizes of MB and GB?

Re: sum

its_anandrjs — Wed, 11 Jun 2014 12:54:31 GMT

You can load your table this way also

LOAD A,

KeepChar(B,.0123456789) as NewBValue,

Right(B,2) as Unit,

KeepChar(C,.0123456789) as NewCValue,

FROM

Book1.xlsx

(ooxml, no labels, table is Sheet1);