topic Re: how to write Sum(columnname) in load statement in QlikView

how to write Sum(columnname) in load statement

Wed, 25 Sep 2013 14:13:45 GMT

Hi,

Could anyone help me how to write Sum(Amount) in Load statement instead of Expression in pivot table.

Thanks.

Re: how to write Sum(columnname) in load statement

Clever_Anjos — Wed, 25 Sep 2013 14:17:11 GMT

A sum into script must include a group by clause

LOAD

ID,

sum(Amount) as Amount_sum

FROM

[your Qvd]

Group by ID;

Re: how to write Sum(columnname) in load statement

jonathandienst — Wed, 25 Sep 2013 14:18:45 GMT

Amelia

Just like that. For example:

LOAD AccountID,

Sum(Amount) As Amount

Resident Accounts

Group By AccountID

All non-aggregated fields (AccountID in this example) should be in a Group By clause.

Regards

Jonathan

Re: how to write Sum(columnname) in load statement

pgrenier — Wed, 25 Sep 2013 14:22:04 GMT

Hello Amelia,

The Sum() function aggregates your data according to a group of fields. So let's say you would like to summarize the total sales of a product per month, your load statement would look something like this:

MonthlySales:

LOAD MonthStart(OrderDate) as OrderMonth

, Product

, Sum(Amount) as MonthlySales

Group By MonthStart(OrderDate), Product;

LOAD OrderDate

, Product

, Amount

From ...

Regards,

Philippe

Re: how to write Sum(columnname) in load statement

Wed, 25 Sep 2013 15:03:27 GMT

Thanks and I used same but it's getting

Error: Invalid Expression while reloading
Could you help how to solve this.