topic Re: How to create an aggregated column in QlikView ? in QlikView

How to create an aggregated column in QlikView ?

Wed, 04 Nov 2015 08:37:05 GMT

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

Re: How to create an aggregated column in QlikView ?

Mark_Little — Wed, 04 Nov 2015 10:48:21 GMT

Hi,

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

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

Re: How to create an aggregated column in QlikView ?

jagan — Wed, 04 Nov 2015 10:57:40 GMT

Hi,

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

=Sum(Sales)

=Count(TransactionID)

Hope this helps you.

Regards,

Jagan.

Re: How to create an aggregated column in QlikView ?

Gysbert_Wassenaar — Wed, 04 Nov 2015 10:58:29 GMT

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?

Re: How to create an aggregated column in QlikView ?

miguelbraga — Wed, 04 Nov 2015 11:20:00 GMT

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,