topic Re: Only SUM from one sheet (Excel) in QlikView

Only SUM from one sheet (Excel)

Thu, 11 Sep 2014 09:27:41 GMT

Hello,

I have to sheets in excel. I have a ID in both of them. In the first sheet i have some data connected to it and in the second sheet i have description of what the ID means.

I want to make a chart showing the SUM of all ID. But i only want to SUM the ID from sheet 1. Because now when i go to SUM(ID) it will also include the one in sheet 2. Which is false, since they are only there so i can get a definition of the ID.

Hope you understand.

Regards,

Erik

Re: Only SUM from one sheet (Excel)

Anonymous — Thu, 11 Sep 2014 09:31:20 GMT

you should an additional Expression from sheet 1

load

id as Sheet1id

from excel

then you can use sum(Sheet1id) - do you want sum or Count?

there is no other way as QV does not know what ID you want

Re: Only SUM from one sheet (Excel)

Thu, 11 Sep 2014 09:35:42 GMT

OK nice, i tried to go with..

load

id as sheet1id

But that did not work..

But your solution

load

id as sheet1id

did work perfectly.

thank you!!