topic Re: Sum function on load script in QlikView

Sum function on load script

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

Hi guys,

I have this script:

tmp:

Crosstable(category, value, 2)

LOAD startDate,

endDate,

categoryA

categoryB

categoryC

FROM ...

Outputs:

LOAD startDate,

endDate,

category,

sum(value) as Total

FROM ...

Group by category

The first script (tmp) works and create the table.

The second script (Outputs) trowh an exception, invalid expression.

I don't understand why?

Please help me.

Thanks.

Re: Sum function on load script

rubenmarin — Wed, 07 Mar 2018 11:05:53 GMT

Hi Andrea, the group clause should have all field outside an agregation function:

Outputs:

LOAD startDate,

endDate,

category,

sum(value) as Total

FROM ...

Group by startDate, endDate, category;

Or something like:

Outputs:

LOAD Min(startDate) as startDate,

Max(endDate) as endDate,

category,

sum(value) as Total

FROM ...

Group by category

Re: Sum function on load script

Anonymous — Wed, 07 Mar 2018 11:09:58 GMT

I've used the first solution and it works very good.

Thanks

Re: Sum function on load script

jyothish8807 — Wed, 07 Mar 2018 11:12:10 GMT

Hi Andrea,

Try like this:

tmp:

Crosstable(category, value, 2)

LOAD startDate,

endDate,

categoryA

categoryB

categoryC

FROM ...

Outputs:

LOAD startDate,

endDate,

category,

sum(value) as Total

FROM ...

Group by category,startDate,endDate;

Your all the fields with in with table apart from the aggregated filed should be in group by.

Br,