Creating aggregations

[#1]

Hi.

I have connected QlikView to a SQL Server db to view a particular table (Table1) on a sheet.

In this table are present some numeric values. I want to calculate the related aggregations (sum). So when I select a value in a list box over a table (Table2) linked to the Table1 by a foreign key, in the box table I want to see the sums and not the original numeric values of the Table1.

Is it possible, please? How? Thanks for your suggests.

[deepakk]

hi,

Aggregate is at script level using group by..

eg:

Laod

a,b, sum(Value) from Qvd group by a,b.

or

if your using QV10 then you have an option of adding expression.

like

aggr(sum(Value) ,a,b)

[#3]

Hi Deepak,

I have QV 10. At script level I'm using the SQL command to read my SQL Server table. Do I use the LOAD command? QVD? Thanks

[deepakk]

hi,

if you want to keep the original data also. then write in below way

Test:

Sql Select * from table;

Laod

a,b,sum(Value) resident Test group by a,b;

or

Sql Select a, b, sum(Values) from table1 group by a,b;