topic Re: Help in SUM Function during Load Data in QlikView

Help in SUM Function during Load Data

nicholas5141 — Thu, 19 Nov 2015 03:45:06 GMT

Hi, need help on SUM function during load data it keep getting error on Invalid expression when I sum(score) as Point as per attached qvw file.

Thank you!

tamilarasu — Thu, 19 Nov 2015 10:05:20 GMT

Hi Nic,

You need to use group by statement and all field names like below,

Student:

LOAD Student_name,

Category,

Score,

SUM(Score) as Point

FROM

[student_grade].xlsx

(ooxml, embedded labels, table is Sheet1)

Group by Student_name,Category,Score ;

tamilarasu — Fri, 20 Nov 2015 01:32:48 GMT

Hi Nic,

Did you get the expected output.?

nicholas5141 — Fri, 20 Nov 2015 02:12:21 GMT

I get invalid expression error but I manage to solve it by adding resident load to perform sum.