topic Creating aggregations in QlikView

Creating aggregations

Mon, 21 Feb 2011 10:03:28 GMT

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.

Creating aggregations

deepakk — Mon, 21 Feb 2011 10:23:01 GMT

hi,

Aggregate is at script level using group by..

eg:

Laod

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

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

aggr(sum(Value) ,a,b)

Creating aggregations

Mon, 21 Feb 2011 10:50:57 GMT

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

Creating aggregations

deepakk — Mon, 21 Feb 2011 11:26:49 GMT

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;

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