Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a aggrgated calculation for a single column in qlikview . Can anyone tell me how do i do that ?
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
Hi,
Try like this using Sum(), Count(), Avg()
=Sum(Sales)
=Count(TransactionID)
Hope this helps you.
Regards,
Jagan.
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?
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