How to create an aggregated column in QlikView ?

[#1]

I need a aggrgated calculation for a single column in qlikview . Can anyone tell me how do i do that ?

[Mark_Little]

Hi,

You would need to Use the AGGR() function in the frontend

like

AGGR(SUM(Sales), SalesPerson)

Or you can make Aggregation tables in the script

Load

     SalesPerson,

     Sum(Sales)

Resident 'SalesTable'

Group By SalesPerson;

Hope this Helps

Mark

[jagan]

Hi,

Try like this using Sum(), Count(), Avg()

=Sum(Sales)

=Count(TransactionID)

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar]

Sum(MyField) is an aggregation. Count(MyField) is another. What kind of aggregation do you need? And where do you need it? As a value in a textbox? Or as an expression in a chart?

[miguelbraga]

Hi Ankit,

As Mr. gwassenaar‌ have asked, what is the agregation you need to make? I kindly advise you to ask a clear question and/or specify better your problem, it will help you in the future . So... Can you please elaborate your question with an Excel file with your needs or a QVW sample?

Regards,

MB