topic Re: What's wrong with my script?? in QlikView

What's wrong with my script??

Wed, 25 May 2011 10:46:02 GMT

Dear QV users,

I am trying to group my table. Before doing this I would like to ad sum() to some fields that are going to be grouped in values. See attachment 'forum qv'. When running this script I am receiving the following script failure (see attachement 'forum qv failure') Cann someone help me explain what is wrong here??

regards,

Aissam

What's wrong with my script??

Wed, 25 May 2011 10:48:48 GMT

I don't think you can use sum() in the script...

What's wrong with my script??

Wed, 25 May 2011 11:00:04 GMT

Hi,

Have you given the group by clause in your script?

What's wrong with my script??

Wed, 25 May 2011 11:24:22 GMT

Not yet, trying first to create the sum function..

Re: What's wrong with my script??

jonathandienst — Wed, 25 May 2011 11:25:22 GMT

Aissam

You must use Group By with an aggregate function like sum(). Use the following syntax

LOAD Key,
     Value,
     Sum(Amount) AS TotalAmount
Resident MyTable
Group by Key, Value;

The group by statement should contain all the fields in the query that are not in an aggregate function. The field names must be the source table names.

Hope that helps

Jonathan

What's wrong with my script??

kaushiknsolanki — Wed, 25 May 2011 11:28:30 GMT

Hi,

You must use group by statement when you use sum() in load.

You must include all the field except the sum() in your group statement.

Just like below.

Load

sum(c) as C

Resident XXX

Group by A,B;

Regards,

Kaushik Solanki

What's wrong with my script??

Wed, 25 May 2011 14:03:19 GMT

Thanks guys,

It worked.

With kind regards,

Aissam

What's wrong with my script??

kaushiknsolanki — Wed, 25 May 2011 18:03:32 GMT

Hi,

Can you please mark this post as Answered. So that Qlikview Group can look at the other post too.

Regards,

Kaushik Solanki