Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qv_jagan
Contributor

Advanced Aggregate

Hello,

Could some one let me know what is aggregate &  advanced aggregate functions and how to use it.

Thanks,

Jagan. V

Tags (3)
2 Replies
MVP
MVP

Re: Advanced Aggregate

Hi,

Aggregate functions are Sum, Max, Min, Avg etc., this are straight forward functions.

Aggr is an Advanced Aggregate function.

Difference between this two types are

Aggregation functions straight away calculate the value, where as Advanced Aggregate functions aggreates by given dimension.

For example

Sales:

LOAD * INLINE [

    BillNo, CostPrice, SellingPrice

    1, 1000, 1200

    2, 500, 650

    3, 200, 300

];

When we calculate Profit % (SellingPrice/CostPrice) by using

Aggregate functions:

= Sum(SellingPrice)/Sum(CostPrice) = 1.264 

Advanced Aggregation functions:

= Sum(Aggr(Sum(SellingPrice)/Sum(CostPrice), BillNo))  = 4 (1.2 + 1.3 + 1.5)

here the profit is calculated by billno and then it is summed up.

Hope this helps you.

Regards,

Jagan.

msheraton
Contributor III

Re: Advanced Aggregate

You could try looking in the QlikView Reference Manual, page 289 to be specific

Community Browser