topic Re: Sum in the script in QlikView

Sum in the script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expetise

How to perfrom sum in script . I am trying to write
sum(A) - sum(B) as Result
i have taken the resident of the table and used group by also but while reloading it shows the error .
how to handel this ?

Thanks in advance

Re: Sum in the script

StarinieriG — Wed, 09 Oct 2019 07:48:57 GMT

Hi,

maybe you are missing a field inside group by.

Could you share your script?

Re: Sum in the script

smilingjohn — Wed, 09 Oct 2019 09:27:09 GMT

This is not working

Test:
LOAD Month,
O,
C
FROM
[C:Sample-Runing.xlsx]
(ooxml, embedded labels, table is Sheet1);

Load
Month,
Sum(C)-sum(O) as Running
Resident Test
Group by Month;

When loaded this is giving the error

Re: Sum in the script

Brett_Bleess — Mon, 14 Oct 2019 19:33:18 GMT

John, what is the error you are receiving? Screenshot would likely be best, this should give us something better to go on here, as at the moment I have no idea.

Regards,
Brett